Macro - Error Message

Posted by Corey on June 28, 2001 8:58 AM

I just started receiving the following Microsoft Visual Basic error message:

"The macros in this project are diabled. Please refer to the online help or documentation of the host application to determine how to enable macros."

I receive this error message every time I open a new worksheet. I have not created any macros, but have opened worksheets that do have macros recently.

Posted by Cory on June 28, 2001 9:48 AM

There could be two reasons. I'll start with the most likely:

The security level of your macros (whether they still exist or not) is set to "high" meaning excel won't run the workbook with macros enabled. To change this go to:
Tools --> Macros --> Security and set the level to at least medium. (Don't set this to low if you view workbooks NOT created by you.

Or, you've loaded a workbook or add-in that contains macros without digital signatures. You have to have software for creating digital signatures, so this one is unlikely.

Any help?
Cory

Posted by Corey on June 28, 2001 3:14 PM

Solution #1 solved it. Thanks!