View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Dave Peterson
 
Posts: n/a
Default Protect formulas but allow deletion of rows?

Maybe you could give them a macro that would unprotect the worksheet, do the row
deletion and then reprotect the worksheet.

You could even build checks into your code that only certain rows can be
deleted.

Hubitron2000 wrote:

I have a sheet where all the formulas must be preserved exactly, but I want
users to be able to delete rows with cells containing those protected
formulas. Is this possible?


--

Dave Peterson