Excel 2007 Macro Security

[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?

 

[Gord Dibben]

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

 

[Jim Rech]

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?

 

[Mary Fetsch]

Thanks a lot!

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

 

[Mary Fetsch]

Thanks! Those things aren't true in this case, but it's good to know for
future reference.