ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Need to use Replace menu when the sheet is protected (https://www.excelbanter.com/excel-programming/382036-need-use-replace-menu-when-sheet-protected.html)

rama

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



All times are GMT +1. The time now is 02:02 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com