Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
INSERTING ROWS IN PROTECTED WORKSHEET
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Inserting rows into worksheets that are protected | Excel Worksheet Functions | |||
In a protected worksheet allow users to delete rows | Excel Worksheet Functions | |||
protection and inserting rows | Excel Worksheet Functions | |||
how to hide rows in a protected sheet | Excel Worksheet Functions | |||
How use group and ungroup functions while worksheet is protected | Excel Worksheet Functions |