Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
command button to unhide row | Excel Discussion (Misc queries) | |||
Hide/Unhide | Excel Discussion (Misc queries) | |||
Why won't my unhide command work? | New Users to Excel | |||
Activex command to Hide/Unhide | Excel Worksheet Functions | |||
Command Button to Hide/Unhide Rows | Excel Discussion (Misc queries) |