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