vba code to enable macros

V

varsha12

Hi,
Can we write a vba code to enable macros. In most of the sites it says
we cant do that . The only thing we can do is change the macro setting or
work around is hide the sheet which has macros. But none of them will work in
my case. Can we change an excel security setting to from macro on open so
that macros are enabled.
 
M

Mike Fogleman

No. If we can do that with code, then so could a hacker with bad intentions.

Mike F
 
P

Paul

This is a bit of the chicken and egg.

You can't run ANY macro unless it is enabled. Therefore, you can't change
with vba the security setting to enable macros. Otherwise, the malevolent
would have a field day !!
 

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

Need Help with Macro Security 1
Quicker way to enable macros? 3
VBA word change keys 0
Convert old wordbasic code into VBA that will run now 0
Want to have macro execute automatically when doc created 3
Just switched to Excel 2007 from 2003 - Unclear how to enable macros 2
VBA code won't run, even with Macro Security set to Enable All Macors 9
WordBasic to VBA conversion 3

Top