Hi,

Does anybody know if it is possible to change the macro security level
using VBA ?

I am currently using Excel 2003 but workbooks may have to be
distributed to Excel 2000 & 97 users. I assume that if code is
available it will work on both 2000 & 2003 but not sure how 97 will
work

Any suggestions / ideas gratefully received

Regards

"michael.beckinsale" wrote in message
m...
Does anybody know if it is possible to change the macro security level
using VBA ?

No, this is not possible. It would defeat the purpose of having macro
security if there were such a way.

I am currently using Excel 2003 but workbooks may have to be
distributed to Excel 2000 & 97 users. I assume that if code is
available it will work on both 2000 & 2003 but not sure how 97 will
work

This is a different issue from macro security. The only way to determine
whether your workbooks will work correctly in Excel 97 is to test them with
Excel 97.

--
Rob Bovey, Excel MVP
Application Professionals
http://www.appspro.com/

* Take your Excel development skills to the next level.
* Professional Excel Development
http://www.appspro.com/Books/Books.htm

While it is not possible to modify the security settings (if you could then
that is what a virus would do and defeat the whole point of security
settings) there are a few things that you can do.

There are ways to electronically sign macros so that they will run
regardless of security settings, but you have to pay for the right to sign
macros and jump through a few hoops to get one in the first place.

The other option which is easy and free is to have a sheet which explains to
a user how to set the proper security settings. This sheet is hidden when an
on_open macro runs. So if they have the proper security settings, they never
see it. Otherwise they are prompted with instructions. I have used this
fairly successfully.

HTH

"michael.beckinsale" wrote:

Hi,

Does anybody know if it is possible to change the macro security level
using VBA ?

I am currently using Excel 2003 but workbooks may have to be
distributed to Excel 2000 & 97 users. I assume that if code is
available it will work on both 2000 & 2003 but not sure how 97 will
work

Any suggestions / ideas gratefully received

Regards