Re: Sheet Protect

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: Frank Kabel (frank.kabel_at_freenet.de)
Date: 12/15/04 

Date: Wed, 15 Dec 2004 09:00:13 +0100

Hi
Excel 97 does not support all the properties/methoads which Excel 2003 does.
Don't have Excel 97 on my office PC. but try:
Active***.Protect DrawingObjects:=True, Contents:=True,
'Active***.EnableSelection = xlUnlockedCells

Or just have a look in Excel's 97 help which methods are really supported
for Protect and Enableselection 

-- 
Regards
Frank Kabel
Frankfurt, Germany
Maurie wrote:
> The message reads "Unprotect method of Work*** class
> Failed."
> The version on my machine (the NT machine) is Excel 97 SR-2
> (I).  The XP machine is Excel 2003 SP 1.  It works on the
> XP machine, the error is produced in the NT machine.
>
>> -----Original Message-----
>> 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 *** with a bunch of Option Buttons, Check Boxes
>>> and cells for input.  To unprotect the *** so the
>>> buttons would work I used:
>>>   Active***.Unprotect
>>> To protect everything I used:
>>> Active***.Protect DrawingObjects:=True, Contents:=True,
>>> Scenarios:=True
>>>    Active***.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?
>>
>>
>> .
Quantcast