View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
rama rama is offline
external usenet poster
 
Posts: 13
Default Need to use Replace menu when the sheet is protected

Hi,

I have a protected worksheet. In that some cells are protected and some of
them are not.
now i wanted to use find/replace feature to replace the data in the unlokced
cell.

It says i can't use that option when the sheet is protected.

is there any way, i can use this feature even if the sheet is protected,

Thanks
Rama