hide formulas

amna77 · May 14th, 2002, 01:14 PM

hi,
Is ther anyway that you can hide formula's in selected range?

Thanks

Mudface · May 14th, 2002, 01:19 PM

There's a couple of ways you might want to consider- first, click on Tools-Options and the 'View' tab, uncheck the Show Formula Bar box. The second needs a bit of code, add these lines to the workbook module in the VBA editor: -

Private Sub Workbook_BeforeClose(Cancel As Boolean)

Application.DisplayFormulaBar = True

End Sub

Private Sub Workbook_Open()

Application.DisplayFormulaBar = False

End Sub

amna77 · May 14th, 2002, 01:41 PM

Thank you very much.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

May 14th, 2002, 01:14 PM	#1
amna77 Board Regular Join Date: May 2002 Posts: 251	hi, Is ther anyway that you can hide formula's in selected range? Thanks

May 14th, 2002, 01:19 PM	#2
Mudface MrExcel MVP Join Date: Feb 2002 Location: Sunny, spring-like Hull Posts: 3,339	There's a couple of ways you might want to consider- first, click on Tools-Options and the 'View' tab, uncheck the Show Formula Bar box. The second needs a bit of code, add these lines to the workbook module in the VBA editor: - Private Sub Workbook_BeforeClose(Cancel As Boolean) Application.DisplayFormulaBar = True End Sub Private Sub Workbook_Open() Application.DisplayFormulaBar = False End Sub

May 14th, 2002, 01:41 PM	#3
amna77 Board Regular Join Date: May 2002 Posts: 251	Thank you very much.