Macro Security

M

mcarter

I have a excel worksheet that has many macros and the worksheet is quite
large. I'm not sure what happened, but all of a sudden the worksheet opens
and will not run any macros. It has the security level is high. I check the
security level and it's on medium. the worksheet used to ask the "enable" or
"disable" macro question when opening the worksheet, but all of a sudden it
doesn't. And like I said, the security level is medium, not High. When I
open my worksheet I can't run the macros!! Help!!! What can I do to force
the enable/disable macro dialog box to come up on opening the worksheet?
 
J

Joel

You may have an Workbook OPen Event that is failing. Try opening the
workbook and have the Workbook OPen function Disabled. When yhou ared
opening the workbook hold the SHIFT KEY down which will disable the WorkBook
Open Event.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Macro security level 6
Excel Macro Security 2
Run Macro If Cell have "x" value 0
Bogus Excel 2002 Macro Security Message 6
Set macro security level to 'low level' on opening a certain workbook. 2
Forcing Macros to Run 2
Macros disabled, not by security settings? 5
Macro Dialog Box 7

Top