Forumla

[ant]

Is there any way that i can hide the forumals that i
created in my file. i still want the forumals to work


I dont want my coworkers to see the forumals that i used

Any ideas?

Ant

 

[J.E. McGimpsey]

Select the cells with formulas and choose Format/Cells/Protection
and check the Hidden checkbox. Protect the sheet using
Tools/Protect/Worksheet and supplying a password.

Note, however, that if your coworkers want to get the formulas, and
have rudimentary intelligence or web search skills, they can get
them. See

http://www.mcgimpsey.com/excel/removepwords.html

for an explanation of why password protection is so weak.

 

[ANT]

iS THERE A WAY THAT THE FORUMAL CAN NOT BE SEEN?

I STILL SEE THE FORUMALS

 

[Ken Wright]

And the need for the caps was???????

If you have followed JE's instructions to the letter, then you should not see the formulas. You
did protect the sheet didn't you??