S
Sandy
Excel 2007 -The following works just fine :-
Sub DisplayRibbon()
Application.DisplayFullScreen = False
End Sub
However when I do this :-
Private Sub Workbook_BeforeClose(Cancel As Boolean)
DisplayRibbon
******Other code here******
End Sub
the formula bar displays and but not the Menus or Ribbon.
Any ideas?
Sandy
Sub DisplayRibbon()
Application.DisplayFullScreen = False
End Sub
However when I do this :-
Private Sub Workbook_BeforeClose(Cancel As Boolean)
DisplayRibbon
******Other code here******
End Sub
the formula bar displays and but not the Menus or Ribbon.
Any ideas?
Sandy