from help on protectionmode

True if user-interface-only protection is turned on.

So for me, that doesn't even appear to be the correct attribute to check.

There are four attributes that need to be checked if you want to see if a
sheet is protected, but protectcontents would definitely affect what you are
trying to do.

from help on protectcontents:
True if the contents of the sheet are protected.

--
Regards,
Tom Ogilvy

"gareth surgenor" wrote in message
...


Update:=

Your advice worked, but I had to find a way of confirming if the
worksheet was already protected or not.

activesheet.protectionmode seems like the right command, but it doesn't
work correctly. I got round it by using activesheet.protectcontents,
which returns F or T depending on whether the sheet is protected.

Many thanks again, Gareth

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!