Hide and unhide command gridlines etc...

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!
 
Top