ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Hiding Formula in cells (https://www.excelbanter.com/excel-discussion-misc-queries/2426-hiding-formula-cells.html)

thrava

Hiding Formula in cells
 
Hello everyone,

I used to know this, but ..... old age...

There is a way to hide formulae in cells, but the sheet
needed to be protected I believe.

Anyone knows how this was done?

Thanks


Norman Jones

Hi Thrava,

Format | Cells | Select Protection tab | Check "Hidden"
Then protect the worksheet.


---
Regards,
Norman



"thrava" wrote in message
...
Hello everyone,

I used to know this, but ..... old age...

There is a way to hide formulae in cells, but the sheet
needed to be protected I believe.

Anyone knows how this was done?

Thanks




Thrava

That's it.
Thank you
And Happy Hollidays

-----Original Message-----
Hi Thrava,

Format | Cells | Select Protection tab | Check "Hidden"
Then protect the worksheet.


---
Regards,
Norman



"thrava" wrote in

message
...
Hello everyone,

I used to know this, but ..... old age...

There is a way to hide formulae in cells, but the sheet
needed to be protected I believe.

Anyone knows how this was done?

Thanks



.



All times are GMT +1. The time now is 01:21 PM.

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