![]() |
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