M
Michael Vautour
I'm triing to do to things in VB the first is to unhide
the items listed in macro below on all my worksheets in a
workbook. I can only get it on the active window. Here's
the present code!
Application.CommandBars("Worksheet Menu Bar").Enabled =
True
Application.DisplayFullScreen = False
Application.DisplayFormulaBar = True
Application.DisplayScrollBars = True
Application.DisplayStatusBar = True
With ActiveWindow
.DisplayGridlines = True
.DisplayHeadings = True
.DisplayHorizontalScrollBar = True
.DisplayVerticalScrollBar = True
.DisplayWorkbookTabs = True
.DisplayOutline = True
End With
The second thing is that I'm triing to find a way to hide
in another macro the menu bar and gridlines in a worksheet
that has a chart! Can seem to get it to work!
Thanks in advance for your help!
the items listed in macro below on all my worksheets in a
workbook. I can only get it on the active window. Here's
the present code!
Application.CommandBars("Worksheet Menu Bar").Enabled =
True
Application.DisplayFullScreen = False
Application.DisplayFormulaBar = True
Application.DisplayScrollBars = True
Application.DisplayStatusBar = True
With ActiveWindow
.DisplayGridlines = True
.DisplayHeadings = True
.DisplayHorizontalScrollBar = True
.DisplayVerticalScrollBar = True
.DisplayWorkbookTabs = True
.DisplayOutline = True
End With
The second thing is that I'm triing to find a way to hide
in another macro the menu bar and gridlines in a worksheet
that has a chart! Can seem to get it to work!
Thanks in advance for your help!