ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Protecting my formulas (https://www.excelbanter.com/excel-discussion-misc-queries/61008-protecting-my-formulas.html)

marko

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


KL

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


marko

Protecting my formulas
 
Thanks KL!

Best Regards,
Marko (not Marco)



All times are GMT +1. The time now is 09:01 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com