Forumla

  • Thread starter Thread starter ant
  • Start date Start date
A

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