I am using the macro from Dave McRitohie
(http://www.mvps.org/dmcritchie/excel/insrtrow.htm) to insert rows in a
spreadsheet and include only the formulas in the inserted rows. The problem
I am having is that I also want to lock my spreadsheet so that users cannot
type over the formulas, when I run the macro in a locked spreadsheet, it
inserts the rows but gives me an error: Run-time error'1004': the cell or
chart you are trying to change is protected and therefore read-only...

Also, I have a formula in my spreadsheet to calculate holding times and take
into consideration weekends, evenings, and holidays... or so I thought. It
counted the 4th of July as a regular working day instead of a holiday. Here
is my formula:

=IF(G12="NA",(NETWORKDAYS(D12,K12)-1)/2.67+(L12-E12),(NETWORKDAYS(G12,K12)-1)/2.67+(L12-H12))

Can anyone help me?