View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
DrDisk7 DrDisk7 is offline
external usenet poster
 
Posts: 3
Default How to delete the content of all unlocked cells in a protected she

I want to "zero" or "blank" all unlocked cells in a protected sheet or
workbook in Excel 2003 or later. I want to keep all locked cells untouched
and also keep the formatting and locked formulas as is for the whole sheet
(or workbook). In my view, this should be just a click on a button in Excel.
Please help! It would make life so much easier.