How to prevent users from Showing Formulas

[Williamyoung351]

I have a workbook where it would not be practical to reformat all of the cells in order to hide the formulas, however, i need to be able to hide them from the users.


I have tried using the If formula below to prevent the Show Formulas function from working but am unsure how to trigger this to run when the button is pressed:


If ActiveWindow.DisplayFormulas = True Then
ActiveWindow.DisplayFormulas = False


ElseIf ActiveWindow.DisplayFormulas = False Then
ActiveWindow.DisplayFormulas = False


Please could someone suggest a fix for me if possible!


Many thanks!

 

[Myrko]

Would it help you if you use View/Show/Hide formulas?

 

[Williamyoung351]

I really need to prevent the show formula function from being able to run in the first place

 

[Chris Macro]

Can't you just password protect the cells so the formulas are hidden?

You could execute VBA code like: ActiveSheet.Cells.Hidden = True to format all the cells and then password protect the sheet.