Mudface - I couldn't get VB for hide formulas to work

smittycft99 · May 14th, 2002, 02:05 PM

Private Sub Workbook_BeforeClose(Cancel As Boolean)

Application.DisplayFormulaBar = True

End Sub

Private Sub Workbook_Open()

Application.DisplayFormulaBar = False

End Sub

I am a VB newbie and I pasted this info into the code for the worksheet, but I can still see the formulas.

NateO · May 14th, 2002, 02:35 PM

These are workbook event procedures, they belong in a specific module called 'ThisWorkbook.' The easiest way to access this module is to right click on the XL icon to the right of your 'File' menu heading and then click 'view code.' You can then paste this code into the module. If have placed the code anywhere else in the workbook, you should delete it.

Hope this helps.

May 14th, 2002, 02:35 PM	#2
NateO Legend Join Date: Feb 2002 Location: Minneapolis, Mn, USA Posts: 9,704	These are workbook event procedures, they belong in a specific module called 'ThisWorkbook.' The easiest way to access this module is to right click on the XL icon to the right of your 'File' menu heading and then click 'view code.' You can then paste this code into the module. If have placed the code anywhere else in the workbook, you should delete it. Hope this helps. __________________ Regards, Nate Oliver Microsoft Excel MVP Nate's Excel Blog

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

May 14th, 2002, 02:05 PM	#1
smittycft99 Board Regular Join Date: Apr 2002 Posts: 130	Private Sub Workbook_BeforeClose(Cancel As Boolean) Application.DisplayFormulaBar = True End Sub Private Sub Workbook_Open() Application.DisplayFormulaBar = False End Sub I am a VB newbie and I pasted this info into the code for the worksheet, but I can still see the formulas.