In Workbook_Open() I set .DisplayFormulaBar = False and some other commands for full screen mode.
I have an ActiveX button that calls this basic macro...
Private Sub CommandButton7_Click()
With ThisWorkbook.Application
.ScreenUpdating = False
Call Tools
.ScreenUpdating = True
End With
End Sub
When the code completes my spreadsheet will not allow me to enter any data in any cells. Like my keyboard is disabled (mouse works and typing works in other workbooks/programs).
However, if I modify the same code to this...
Private Sub CommandButton7_Click()
With ThisWorkbook.Application
.ScreenUpdating = False
Call Tools
.DisplayFormulaBar = True 'added this!
.DisplayFormulaBar = False 'added this!
.ScreenUpdating = True
End With
End Sub
...everything works fine.
I previously had a form control button running this macro and had no issues. I had to change it to an ActiveX button for programming purposes.
Does anyone know why .DisplayFormulaBar causes this and what I can to to clean up my code?
Bookmarks