Sheet protection bug??

  • Thread starter Thread starter Dag Johansen
  • Start date Start date
D

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
 
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 .
 
Back
Top