Excel 2007: where to find the option 'Trust access to Visual Basic Project?

4

I tried to run a plugin in Excel 2007, and I got this error message

enter image description here

Do anyone know how I can access this feature from the 2007 GUI? I am confused by the new interface.

Anthony Kong

Posted 2011-06-21T07:20:16.490

Reputation: 3 117

Answers

3

Try:

Office Button->Excel Options(at the bottom)->Trust Center->Trust Center Settings->Macro Settings->Trust Access to the VBA project model

Charles Williams

Posted 2011-06-21T07:20:16.490

Reputation:

Ah! Trust center! No wonder I couldn't find the security tab. jesus wtf. – Scott – 2013-06-07T22:55:11.803

2

The office menu (one with office logo on it, on left top) -> Excel options -> Trust Center -> Trust Center Settings (button) -> Macro Settings -> Trust access to VBA project object model.

Is this what you are looking for?

shahkalpesh

Posted 2011-06-21T07:20:16.490

Reputation: 141

@shahkalpesh: your answer is also correct. Wish I can accept more than one answer. Thanks for your help! – Anthony Kong – 2011-06-22T01:08:15.883

Asked: 2011-06-21T07:20:16.490

Viewed: 5 815 times

Active: 2011-06-21T10:40:45.087