enable macros

G

Guest

Hi, I don't want to change the security on the user level, but have a file in
which I'd like to automatically enable macros when the file opens (meaning
not have to click on the yes to let macros run). The display alerts didn't
seem to work. I tried to search for an answer before posting this question,
but was unlucky. Thanks much,

Aaron
 
G

Guest

pragmatically correct and an excellent answer. Just to add some peripheral
information, in xl2002 and xl2003, a running macro can change the security
setting when opening another file programmatically. But this has no
application to the question asked because it can't be employed by the file
being opened.
 

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

Just switched to Excel 2007 from 2003 - Unclear how to enable macros 2
Forcing Macros to Run 2
Macros... 3
Macro security level 6
security, enabling macros to enable a disabling saving function 12
Set macro security level to 'low level' on opening a certain workbook. 2
Turn display alerts off then back on at close 1
vba code to enable macros 3

Top