MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Hide formula box

Posted by M on November 24, 2001 4:35 PM

Is there any way to automatically hide a formula bar when the user opens the spreadsheet and then prevent the user from viewing the formual bar as long as the report is open?

Posted by Luis B on November 24, 2001 10:03 PM

Yes there is.
Press Alt+F11 on the spreadsheet you want to make this change into.
Then paste the following coding into the "This project", "Workbood" "Open" Sub:
Application.DisplayFormulaBar = False
This will do it.
Good luck,