macro enable/disable

S

scott_hanebutt

I have a macro that opens a project file. That file may or may not have
macros in it. If it does I get the question to enable them or not. I want
to get rid of the question. Is there any way of doing so without manually
changing my macro security setting (can I change the setting through code and
then change it back)? Sendkeys does not work and I don't want to use digital
certificates.

Thanks,
Scott Hanebutt
 
J

Jan De Messemaeker

Hi Scott,

No, you cannot change security through a macro, that would defeat the whole
idea of the security itself.
In an environment where any VBA is used, I always tell tyhe ciustomer as
soon as he installs Project to put Macro Security to low.
 

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