Replace feature disabled?

M

Matt

I have an Excel application that is password protected. While it is password
protected the Replace feature is disabled. When I unprotect the document,
the Replace feature is enabled again. Is there a way around this? Thanks in
advance. Matt
 
M

Myrna Larson

Password protection is there to prevent changes. Evidently the internal code
for the Search and Replace function doesn't look for locked cells. If that's
the case, you can't do anything other than what you are already doing --
unprotect, replace, and protect again.
 
M

Matt

The problem is that not all of the cells on the worksheet are locked and I
want the user to be able to change certain cells. The Replace feature is not
even available for the unlocked cells. Thanks.
 
M

Myrna Larson

Yes, probably because the code wasn't written to handle the requirement to
search only in unlocked cells.
 
Top