thanks folks!
good advice.
Jase


Tom Ogilvy wrote:

if in xl2002 and later, a high security setting disables macros for
uncertified workbooks. Once the macros are disabled, there is no way for you
to tell the user anything or attempt to change anything. The usual
recommendation is to put macros in your workbook that will hide all sheets
except a message sheet that has a big message saying if you see this message,
you need to set security to medium and close and reopen the workbook. Then
if the workbook opens with macros enabled, your code would restore it to a
working state and return it to the "protected" state upon closing.

--
Regards,
Tom Ogilvy


"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