Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
worksheet won't change visible status
Private Sub viewNNI()
With Application.CommandBars.ActionControl If ActiveWorkbook.Charts("NNI SALES$").Visible = xlSheetVisibl Then '.State = msoButtonUp ActiveWorkbook.Charts("NNI SALES$").Visible xlSheetVeryHidden ActiveWorkbook.Charts("NNI MARGIN $").Visible xlSheetVeryHidden ActiveWorkbook.Charts("NNI Cumm Sales $").Visible xlSheetVeryHidden ActiveWorkbook.Worksheets("Sales $$").Visible xlSheetVeryHidden Else '.State = msoButtonDown ActiveWorkbook.Charts("NNI SALES$").Visible xlSheetVisible ActiveWorkbook.Charts("NNI MARGIN $").Visible xlSheetVisible ActiveWorkbook.Charts("NNI Cumm Sales $").Visible xlSheetVisible ActiveWorkbook.Worksheets("Sales $$").Visible xlSheetVeryHidden End If End With End Sub i can't get my worksheet name Sales $$ to change its Visible status The worksheet name is correct. All the charts work. I don't understan why this isn't working. Can someone please point out what I'm doin wrong -- Message posted from http://www.ExcelForum.com |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Status bar not visible in my .xlsx worksheets. | Excel Discussion (Misc queries) | |||
How to keep Status count visible? | Excel Worksheet Functions | |||
Variations in a sheet's Visible status | Excel Discussion (Misc queries) | |||
How do I change the display options in the status bar of MS Excel | Excel Discussion (Misc queries) | |||
Check status row (hidden or visible)? | Excel Programming |