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!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Workbook_close 1
Customizing Shortcut Menus 0
Activate Sheet 5
Shared Workbook 12
Controlling user environment 3
MAJOR PROBLEM! --- Menu Bars don't unhide? 9
Hide menu bar 1
Closing Code 0

Top