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?
|