ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Prevent Others from seeing a formula (https://www.excelbanter.com/excel-discussion-misc-queries/114763-prevent-others-seeing-formula.html)

Ed

Prevent Others from seeing a formula
 
How do I prevent from other to see the formula contained in a cell?

thanks

Jim Thomlinson

Prevent Others from seeing a formula
 
You can hide the formula but it requires you to protect the sheet. In the
Format Cell dialog there is a tab called protection. On that thab select
Hidden. Now when you protect the sheet the formula will not be visisble.
--
HTH...

Jim Thomlinson


"Ed" wrote:

How do I prevent from other to see the formula contained in a cell?

thanks



All times are GMT +1. The time now is 04:03 AM.

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