locking formulas??

I

internet team

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.
 
J

JulieD

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
 
I

internet team

Julie,

We tried that...the problem with that is the cells that have the formulas
cannot be locked b/c that is where the data needs to be input...is there a
way to lock the formulas??
 
J

JulieD

Hi

a formula can not contain both a formula and an inputted value - one you
type over the formula its gone.

You could add code to "reenter" the formulas automatically for you when you
need that - or if you'ld like to explain a bit more about what you're trying
to achieve maybe we can come up with a workable solution.

Cheers
JulieD
 
I

internet team

hey, thanks so much...the initial way worked...i just had to adjust a
value...thanks so much!
 
R

Rob

I am having a similar problem and have tried the unlock and hide solutions
without success...

I have a workbook I am sharing with co workers. Many of the cells have
formulas in them that change cell contents based on inputs. Not all the data
is availabel at once and the workbook is meant to be a "tracker" type that
provids alerts when days have passed etc, based on formulas and conditional
formatting values.

I need to make it idiot proof, ie. when someone type a number into the
wrong cell (say one that should have remained empty) by mistake, then tries
to delete the error the cell is now empty... sans formula and the rest of the
row no longer has the useful interactive "tracker" features....

Can anyone help with this? Thank you.
 
B

Bob Phillips

See other question.

--
HTH

Bob Phillips

Rob said:
I am having a similar problem and have tried the unlock and hide solutions
without success...

I have a workbook I am sharing with co workers. Many of the cells have
formulas in them that change cell contents based on inputs. Not all the data
is availabel at once and the workbook is meant to be a "tracker" type that
provids alerts when days have passed etc, based on formulas and conditional
formatting values.

I need to make it idiot proof, ie. when someone type a number into the
wrong cell (say one that should have remained empty) by mistake, then tries
to delete the error the cell is now empty... sans formula and the rest of the
row no longer has the useful interactive "tracker" features....

Can anyone help with this? Thank you.
Click to expand...
 
D

diane

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.
 
Top