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
"varsha12" wrote in message
...
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.

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 !!


--
If the post is helpful, please consider donating something to an animal
charity on my behalf.


"varsha12" wrote:

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.

Thanks.

"Mike Fogleman" wrote:

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

Mike F
"varsha12" wrote in message
...
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.



.