Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel,microsoft.public.excel.misc
|
|||
|
|||
Protecting my formulas
Is there a way that I can protect cells where i have my formulas so
other users CAN'T SEE THEM in the formula bar or in any other way? Thanks, Marko |
#2
Posted to microsoft.public.excel,microsoft.public.excel.misc
|
|||
|
|||
Protecting my formulas
Hi Marco,
1. Select the whole sheet 2. Go to menu FormatCells... tab Protection, uncheck Locked, press OK 3. Select cells/ranges to protect 4. Go to menu FormatCells... tab Protection, check Locked and Hidden, press OK 5. Go to menu ToolsProtect Sheet... and follow the instructions... Regards, KL "marko" wrote in message oups.com... Is there a way that I can protect cells where i have my formulas so other users CAN'T SEE THEM in the formula bar or in any other way? Thanks, Marko |
#3
Posted to microsoft.public.excel,microsoft.public.excel.misc
|
|||
|
|||
Protecting my formulas
Thanks KL!
Best Regards, Marko (not Marco) |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Protecting Formulas from a range from being viewed | Excel Discussion (Misc queries) | |||
Protecting formulas in a workbook | Excel Worksheet Functions | |||
Locking and Protecting and NOT displaying formulas | Excel Discussion (Misc queries) | |||
Protecting Formulas | New Users to Excel | |||
Protecting formulas | Excel Discussion (Misc queries) |