Derrick

A better way could be to add a couple of lines to your macro(s) which
unprotect the sheet, run the code then re-protect the sheet.

Sub Macro1()
Activesheet.unprotect password:="mypass"

code runs here to hide rows or insert formulas

Activesheet.protect password:="mypass"


Gord Dibben MS Excel MVP

On Wed, 24 Jun 2009 06:44:01 -0700, Derrick
wrote:

I have a calculation sheet, where i want to make sure that users dont
accidentally delete the formulas necessary to complete the calculations.
- i've tried protecting the cells, by unlocking certain input cells and
locking the rest, but that for some reason won't allow my 'hide rows, and
insert formulas depending on what is selected from a validated list' macro to
run properly.

my idea now is to have a startup macro, where if the sheet is copied or
whatever, the formulas will be saved in code and inserted into the correct
cells if needed
- or if the formula is accidentally deleted it will re-appear.
where would i insert that coding?

thanks for helping!

Also, if you have a better idea, or a way to fix the 1st problem, let me know!