VBA for Find & Replace function on protected sheet

Hi all,

I need to somehow enable the find & replace function within my workbook without giving clients the password for my protected sheet. Within each sheet, there will be a few hundred unlocked cells, so I want them to be able to do a find & replace in there but not within the locked cells. So if they select locked AND unlocked cells, it should only do the find & replace within the unlocked range.

I currently use below module to do just that. Though, the find & replace window is very generic and a lot worse than the built in one. e.g. it does not tell you how many replacements were made, nor can you undo things (not sure that's feasible with vba). Is there a way to more closely replicate the actual find & replace function?

Please Login or Register  to view this content.

Hi,

Sorry for the late reply. Just tried your code, but it happens to be the same as my version, doesn't seem to make any difference. I have attached a sample workbook for further clarification. In this workbook, the sheet is protected but the grey, blue and green cells are unlocked. This is where people do adjustments and want to use find replace. So basically I want to enable find replace for them but only for these unlocked cells. They shouldn't be able to change any other cells...