MrExcel Publishing
Your One Stop for Excel Tips & Solutions

hide / disable formula bar on"workbook_open"


Posted by Jim on October 28, 2000 3:05 PM

I can hide / close the formula bar with a command button
i.e, application.displayformulabar = false but can't
fig how to on workbook_open any ideas?


Posted by Ivan Moala on October 29, 2000 10:51 PM


Jim

Private Sub Workbook_Open()
Application.DisplayFormulaBar = False
End Sub

Ivan