ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Hidding formulars used in a worksheet (https://www.excelbanter.com/excel-worksheet-functions/140685-hidding-formulars-used-worksheet.html)

Worksheet Formulars

Hidding formulars used in a worksheet
 
I don't want the formular I used in the worksheet to display on the formular
bar. How do I do this?

Mike H

Hidding formulars used in a worksheet
 
One way,

Select all the cells in your worksheet by clicking in the small grey box to
the left of column A. The click Format - Cells - Protection and remove the
locked checkmark.

Now select your cells with formula in and click Format - Cells - Protection
and check the hidden box. Protect the worksheet and your formula are now
hidden.

Mike

"Worksheet Formulars" wrote:

I don't want the formular I used in the worksheet to display on the formular
bar. How do I do this?



All times are GMT +1. The time now is 06:04 PM.

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