Thread: Sheet Protect
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Doug Loewen[_3_] Doug Loewen[_3_] is offline
external usenet poster
 
Posts: 1
Default Sheet Protect

I have a sheet with a bunch of Option Buttons, Check Boxes
and cells for input. To unprotect the sheet so the
buttons would work I used:
ActiveSheet.Unprotect
To protect everything I used:
ActiveSheet.Protect DrawingObjects:=True, Contents:=True,
Scenarios:=True
ActiveSheet.EnableSelection = xlUnlockedCells
WE have several machines with XP and it seems to work
fine, but on the NT machines I get an Error Message.
Is there a fix for this?