Excel 2007 Macro Security

  • Thread starter Thread starter Mary Fetsch
  • Start date Start date
M

Mary Fetsch

I have my macro security set to "Disable all macros with notification".
Normally, if I open a worksheet with a macro, I will see an alert below the
toolbar that macros have been disabled. When I click the Options button next
to that message, I have the option to "Enable this content". Thus, I can
enable the macro if I want to.

I have a worksheet with a macro that had been digitally signed but the
certificate expired. When I open it, I get the same macro warning, but when
I click the Options button, I don't have the "Enable this content" option.
I'd like to use the macro anyway, but I can't. Is there any way I can enable
that macro?
 
Don't know about 2007 but in 2003 and earlier I would open the VBE, select the
workbook/project and Tools>Digital Signature and Remove the DS

Save the workbook.


Gord Dibben MS Excel MVP
 
This is what happens when the workbook has a file save password or the
workbook structure is protected. If that's the case here, the easiest
course is to save it without the password.

--
Jim
|I have my macro security set to "Disable all macros with notification".
| Normally, if I open a worksheet with a macro, I will see an alert below
the
| toolbar that macros have been disabled. When I click the Options button
next
| to that message, I have the option to "Enable this content". Thus, I can
| enable the macro if I want to.
|
| I have a worksheet with a macro that had been digitally signed but the
| certificate expired. When I open it, I get the same macro warning, but
when
| I click the Options button, I don't have the "Enable this content" option.
| I'd like to use the macro anyway, but I can't. Is there any way I can
enable
| that macro?
 
Thanks a lot!

Gord Dibben said:
Don't know about 2007 but in 2003 and earlier I would open the VBE, select the
workbook/project and Tools>Digital Signature and Remove the DS

Save the workbook.


Gord Dibben MS Excel MVP
Click to expand...
 
Thanks! Those things aren't true in this case, but it's good to know for
future reference.
 
Back
Top