Protecting & Unprotecting worksheet
Posted by kh on January 07, 2001 11:21 PM
I've got a simple macro that protects a few sets the worksheet protection on and off using the
On Error Resume Next
I will call this in another procedure if the worksheet is protected to make some amendments to certain hidden cells. However the problem is that the protect and unprotect function is not always working that is I have notice that sometimes when unprotecting the worksheet the worksheet is still in protected mode. Can anyone help.