ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Hide and unhide command gridlines etc... (https://www.excelbanter.com/excel-programming/275573-hide-unhide-command-gridlines-etc.html)

Michael Vautour

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!


All times are GMT +1. The time now is 11:59 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com