vba code to enable macros

  • Thread starter Thread starter varsha12
  • Start date Start date
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.
 
No. If we can do that with code, then so could a hacker with bad intentions.

Mike F
 
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 !!
 
Back
Top