Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
locking formulas??
Thank you this work. Take this one step further. What am I missing? My
formula isn't rounding. =IF(AND(INT(StartDT)=INT(EndDT),NOT(ISNA(MATCH(INT (StartDT), HolidayList,0)))),"0 days 0 hours", IF(INT(StartDT)=INT(EndDT), "0 days " & ROUND(24*(EndDT-StartDT),2)&"hours", MAX(NETWORKDAYS(StartDT+1,EndDT-1,HolidayList),0)+ INT(24*(((EndDT-INT(EndDT))-(StartDT-INT(StartDT)))+ (DayEnd-DayStart))/(24*(DayEnd-DayStart)))& " days "&MOD(ROUND(((24*(EndDT-INT(EndDT)))-24*DayStart)+ (24*DayEnd-(24*(StartDT-INT(StartDT)))),2), ROUND((24*(DayEnd-DayStart)),2))&" hours ")) My version of excel isn't current - I think it is 1998. "JulieD" wrote: Hi you can apply worksheet protection to the sheet first select the cells you want people to access and choose format / cells / protection & untick locked next choose tools / protection / protect sheet - you can add a password, if required. now people can only change the cells that you "unlocked" above hope this helps Cheers JulieD "internet team" wrote in message ... Is there a way to lock formulas? I would like other users to be able to input info, but not be able to change any of the formulas. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
locking formulas?? | Excel Discussion (Misc queries) | |||
Locking formulas | Excel Discussion (Misc queries) | |||
locking formulas | Excel Discussion (Misc queries) | |||
Locking and Protecting and NOT displaying formulas | Excel Discussion (Misc queries) | |||
Locking Sheet names in formulas | Excel Worksheet Functions |