Hi All,

I have a worksheet used for collecting data. The worksheet tab has Unprotected cells that users can enter values into and other Protected cells that they cannot alter.

The Protect format for the cells is set and the Worksheet has password protection.

Fairly normal stuff?

The problem is that Replace is disabled. If a user wants to make the same change (to a highlighted range) of Unprotected cells they cannot use Find/Replace.

Does anyone have thoughts/tips on how to overcome this?

Thanks