Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
can't figure out this bug
Private Sub viewDS()
With Application.CommandBars.ActionControl If ActiveWorkbook.Charts("DS SALES$").Visible = xlSheetVisibl Then .State = msoButtonUp 'If .State = msoButtonUp Then ActiveWorkbook.Charts("DS SALES$").Visible xlSheetVeryHidden .State = msoButtonUp ActiveWorkbook.Charts("DS MARGIN$").Visible xlSheetVeryHidden .State = msoButtonUp ActiveWorkbook.Charts("DS Cumm Sales $").Visible xlSheetVeryHidden .State = msoButtonUp ActiveWorkbook.Charts("DS Cumm Marg $").Visible xlSheetVeryHidden .State = msoButtonUp Else ActiveWorkbook.Charts("DS SALES$").Visible xlSheetVisible * .State = msoButtonDown ActiveWorkbook.Charts("DS MARGIN$").Visible xlSheetVisible .State = msoButtonDown ActiveWorkbook.Charts("DS Cumm Sales $").Visible xlSheetVisible .State = msoButtonDown ActiveWorkbook.Charts("DS Cumm Marg $").Visible xlSheetVisible .State = msoButtonDown End If End With End Sub This snipet of code crashes on the line I have marked with an asterik It gives me the error Object variable or With block variable not set I've declared the with at the very top though so I don't understand wh this is crashing. Can someone help me out -- Message posted from http://www.ExcelForum.com |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
can't figure out this bug
Hi
You are missing a second "End if" at the end. The editor often gives me a message about With...end With, when not closing an If is the real problem. You also have some .State and some State lines (without the dot) - could that be a problem?? regards Paul majikman wrote in message ... Private Sub viewDS() With Application.CommandBars.ActionControl If ActiveWorkbook.Charts("DS SALES$").Visible = xlSheetVisible Then State = msoButtonUp 'If .State = msoButtonUp Then ActiveWorkbook.Charts("DS SALES$").Visible = xlSheetVeryHidden State = msoButtonUp ActiveWorkbook.Charts("DS MARGIN$").Visible = xlSheetVeryHidden State = msoButtonUp ActiveWorkbook.Charts("DS Cumm Sales $").Visible = xlSheetVeryHidden State = msoButtonUp ActiveWorkbook.Charts("DS Cumm Marg $").Visible = xlSheetVeryHidden State = msoButtonUp Else ActiveWorkbook.Charts("DS SALES$").Visible = xlSheetVisible * .State = msoButtonDown ActiveWorkbook.Charts("DS MARGIN$").Visible = xlSheetVisible State = msoButtonDown ActiveWorkbook.Charts("DS Cumm Sales $").Visible = xlSheetVisible State = msoButtonDown ActiveWorkbook.Charts("DS Cumm Marg $").Visible = xlSheetVisible State = msoButtonDown End If End With End Sub This snipet of code crashes on the line I have marked with an asterik. It gives me the error Object variable or With block variable not set. I've declared the with at the very top though so I don't understand why this is crashing. Can someone help me out? --- Message posted from http://www.ExcelForum.com/ |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
can't figure out this bug
Not tested, but would any additional ideas here help?
Private Sub viewDS() Dim Flag With ActiveWorkbook Flag = IIf(.Charts("DS SALES$").Visible = xlSheetVisible, xlSheetVeryHidden, xlSheetVisible) .Charts("DS SALES$").Visible = Flag .Charts("DS MARGIN$").Visible = Flag .Charts("DS Cumm Sales $").Visible = Flag .Charts("DS Cumm Marg $").Visible = Flag .Charts("DS SALES$").Visible = Flag End With End Sub -- Dana DeLouis Using Windows XP & Office XP = = = = = = = = = = = = = = = = = "majikman " wrote in message ... Private Sub viewDS() With Application.CommandBars.ActionControl If ActiveWorkbook.Charts("DS SALES$").Visible = xlSheetVisible Then State = msoButtonUp 'If .State = msoButtonUp Then ActiveWorkbook.Charts("DS SALES$").Visible = xlSheetVeryHidden State = msoButtonUp ActiveWorkbook.Charts("DS MARGIN$").Visible = xlSheetVeryHidden State = msoButtonUp ActiveWorkbook.Charts("DS Cumm Sales $").Visible = xlSheetVeryHidden State = msoButtonUp ActiveWorkbook.Charts("DS Cumm Marg $").Visible = xlSheetVeryHidden State = msoButtonUp Else ActiveWorkbook.Charts("DS SALES$").Visible = xlSheetVisible * .State = msoButtonDown ActiveWorkbook.Charts("DS MARGIN$").Visible = xlSheetVisible State = msoButtonDown ActiveWorkbook.Charts("DS Cumm Sales $").Visible = xlSheetVisible State = msoButtonDown ActiveWorkbook.Charts("DS Cumm Marg $").Visible = xlSheetVisible State = msoButtonDown End If End With End Sub This snipet of code crashes on the line I have marked with an asterik. It gives me the error Object variable or With block variable not set. I've declared the with at the very top though so I don't understand why this is crashing. Can someone help me out? --- Message posted from http://www.ExcelForum.com/ |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
can't figure out this bug
Paul, one of the if's is commented out so thats not the problem.
Dana, thanks for the help. I can get my script to do what yours does i i just remove all the .state lines. However, I need those lines a those lines will either put a check mark or remove a check mark next t the option that was selected. Your script doesn't have tha functionality -- Message posted from http://www.ExcelForum.com |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
HOW TO 'BLINK' A FIGURE INSTEAD OFF BOLDING THE FIGURE | Excel Worksheet Functions | |||
how to figure | Excel Discussion (Misc queries) | |||
Can anyone me help figure this out?? | Excel Discussion (Misc queries) | |||
Can anyone help me figure this out???? PLEASE???!!!??? | Excel Discussion (Misc queries) | |||
Still trying to figure it out | Excel Worksheet Functions |