Auto_Open Macro

B

Brick61

I have several auto_open macros that were created with Excel 2003. To enable
the macro and preventing it from running, I set my security to medium and
hold down the shift key when clicking 'enable macro'.

How can I achieve the same with Excel 2007 so that I can enable the macro,
without it running, and then edit if necessary?
 
B

Brick61

All this does is tell me how to change my security settings. I want to
enable the Auto_Open macro and prevent it from running, so that I can edit
before it runs.
 
B

Brick61

Sorry for the earlier post. I was trying to hold the shift key after I
opened, not when I opened it.

Thanks
 

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

Top