Sheet protection bug??

[Dag Johansen]

I just wanted to add that I run a Win2k/Excel 2k system;
my modules need to work with Excel 2000 and higher.

Sincerely,

Dag

 

[Tom Ogilvy]

You can test each sheet to see if it is protected.

for each sh in thisworkbook.worksheets
if sh.protectContents then
sh.Activate
sh.protect UserInterfaceOnly:=True
End if
Next

In xl2000 and earlier, you can apply UserInterfaceOnly without knowing the
password. I understand you need to supply the password in xl2002 (and
assume xl2003). I am not sure how you intend to do that other than prompt
the user .