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.

0

2 Answers 2

3

Try:

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

1
  • Ah! Trust center! No wonder I couldn't find the security tab. jesus wtf.
    – Scott
    Commented Jun 7, 2013 at 22:55
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?

1
  • @shahkalpesh: your answer is also correct. Wish I can accept more than one answer. Thanks for your help! Commented Jun 22, 2011 at 1:08

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .