You are correct in that you can not read or write to the security settings.
But you can use teh fact that if their security is set to high then no
macro's will run. Create your spreadsheet using the on open and on close
events. In the on close event hide all but one sheet that tells them that
their security is set incorrectly. In the on open add code to unhide all of
the sheets and hide the security instruction page. This way if their security
is set to high then the only thing they will see is your instruction page
telling them to change the security. Otherwise the spreadsheet will function
as normal...
--
HTH...

Jim Thomlinson


"WhytheQ" wrote:

If someone has their security setting put to High is it possible to
either change their setting to Medium programmatically, or get a
message box to pop up and tell them that they need to change their
setting to Medium ?

(I realise that none of the above is propbably possible as the security
setting will be well protected.....but thought I'd ask anyhow, as a lot
of people know nothing about Excel and blame my code when a program
doesn't work - when it is simply that they have their settings too
high)

Any help appreciated
Jason