"Tony White" wrote in message
...

Hello All
I distribute a report in my company and I use code to fill drop-down
boxes and change between sheets. Since I use a pivot table to fill
the drop-down boxes and call on PivotCache, I test in the
workbook_open even to see what version of excel is running. I am
able to successfully allow 2000 and higher users to open the book
and close the workbook for 97 and earlier however some users have
their security settings set to high and they are able to open the
workbook by the code to fill the drop-down boxes has not run.

Is there a way to test what the security level is? I want to return
a msgbox which tells the user to change their security settings to
Medium as I do with the 97 users (I tell them to upgrade to 2000)

Thank for your help!
--
Anthony White


Hi Anthony,

Since they have disabled macros you cannot have anything run
automatically to check.

My response in that situation would be to ensure that when you
distribute the workbook, the relevant sheets are 'very hidden' and
only an instruction sheet is visible saying that the workbook required
macros to be enabled.

In the Workbook_Open event code, just hide that sheet, and unhide the
others.

HTH,

Alan.