Problem using protect/Unprotect in excel 97
 

Hello,

I have tried like 100+ methods of using the protect/unprotect function
in excel 97 vba. ALL of them give me different errors.

If I want to include a simply function to Unprotect and then
re-Protect
something during a given function, What is the "proper" command for
this,
that is excel 97 vba compatible?

Also, I'm assuming that to make it with NO password, use
password:=""?

Thanks in advance,

Spyrule


--
spyrule
------------------------------------------------------------------------
spyrule's Profile: http://www.excelforum.com/member.php...o&userid=25489
View this thread: http://www.excelforum.com/showthread...hreadid=563039

Problem using protect/Unprotect in excel 97
 

Did you try the macro recorder. If not record protect & un-protect the
sheet. In the code as recorded might want to change ActiveSheet to
Worksheets("SheetName").

If your function is used as a UDF it can only return a value and cannot
change formats or settings such as protection, but no problem from a sheet
change/selection event.

Regards,
Peter T

"spyrule" wrote in
message ...

Hello,

I have tried like 100+ methods of using the protect/unprotect function
in excel 97 vba. ALL of them give me different errors.

If I want to include a simply function to Unprotect and then
re-Protect
something during a given function, What is the "proper" command for
this,
that is excel 97 vba compatible?

Also, I'm assuming that to make it with NO password, use
password:=""?

Thanks in advance,

Spyrule


--
spyrule
------------------------------------------------------------------------
spyrule's Profile:
http://www.excelforum.com/member.php...o&userid=25489
View this thread: http://www.excelforum.com/showthread...hreadid=563039