View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Michael Vautour Michael Vautour is offline
external usenet poster
 
Posts: 1
Default Hide and unhide command gridlines etc...

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!