Do Not Run AutoNew Macro

G

Gordon Hyatt

I have a template with an AutoNew macro. I can hold the
shift key when opening the template to prevent the
AutoNew macro from running.

I'm trying to write a macro that will do the same thing.
The Macro Recorder will not recognize the shift key. When
I run the macro to open my template, the AutoNew macro
runs.

Does anyone know VBA code that I can use to Open a
Template for editing and prevent the AutoNew macro from
running?

Thank you,

Gordon
 

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