Thread: Sheet Protect
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Frank Kabel Frank Kabel is offline
external usenet poster
 
Posts: 3,885
Default Sheet Protect

Hi
what exact error message do you get and what Excel version i installed on
this machine

--
Regards
Frank Kabel
Frankfurt, Germany

Doug Loewen wrote:
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?