Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Formula Bar in Excel VBA
Great, it works!!! Thanks a lot.- Alexky
- Post #7
- Forum: VBA Visual Basic for Applications (Microsoft)
-
Formula Bar in Excel VBA
I have simplified a workbook to leave only substitution of the standard menu and delete/restore Formula and Status Bars. The custom menu has the only button exit which seems to be a problem. You can close the workbook using either this button or just closing it with a standard cross button in...- Alexky
- Post #5
- Forum: VBA Visual Basic for Applications (Microsoft)
-
Formula Bar in Excel VBA
Here it is... Private Sub Workbook_Open() On Error Resume Next Application.ScreenUpdating = False InitView Sheets("1st page").Select End Sub Private Sub Workbook_BeforeClose(Cancel As Boolean) On Error Resume Next Application.ScreenUpdating = False...- Alexky
- Post #3
- Forum: VBA Visual Basic for Applications (Microsoft)
-
Formula Bar in Excel VBA
Excel does not restore a Formula Bar. I wrote codes for Open and BeforeClose events to hide and restore Formula, Menu and Tool Bars. It works perfectly when you launch it from VBA editor, but when you open and close a workbook it restores everything but a Formular Bar. I can't understand why...- Alexky
- Thread
- Replies: 6
- Forum: VBA Visual Basic for Applications (Microsoft)
