Hide the formulas

[Tom22]

Hi,
I am using one simple code to protect and unprotect my sheet

It is working fine but only issue is user still able to see formula I have used to fill up numbers.

How can I hide formulas ….I was in impression that by protecting you can hide the formulas as well.

Please suggest

Thank you

 

[AliGW]

No - protecting does not HIDE formulae, but if the cells containing formulae are set as locked (the default), then they cannot be edited, so your formulae are safe. Is there any real reason why your users should not see the formulae?

Have a look here: https://docs.microsoft.com/en-us/office/vba/api/excel.range.formulahidden

 

[Tom22]

Yes that is working fine……Thanks for quick reply

 

[GraH - Guido]

I believe you were after this. So it is possible to "hide" formulae while protecting sheet.