Welcome to OGeek Q&A Community for programmer and developer-Open, Learning and Share
Welcome To Ask or Share your Answers For Others

Categories

0 votes
332 views
in Technique[技术] by (71.8m points)

excel - InCorrect Parameter (VBA Script)

Please help - everything seems correct but still getting incorrect parameter.

Sub Display_Tab_Sales_Revenue()

 With ActiveSheet
    'Visisbility of Tab Buttons
    .Shapes("Revenue_Inactive").Visible = False
    .Shapes("Revenue_Active").Visible = True
    .Shapes("Units_Inactive").Visible = True
    .Shapes("Units_Active").Visible = False
                
    'visibility of Tab Contents
    .Shapes("Map_Chart_Sales_Revenue").Visible = True
    .Shapes("Line_Chart_Sales_Revenue").Visible = True
    .Shapes("Map_Chart_Sales_Units").Visible = False
    .Shapes("Line_Chart_Sales_Units").Visible = False
        
 End With
     
End Sub

Sub Display_Tab_Sales_Units()

 With ActiveSheet
    'Visisbility of Tab Buttons
    .Shapes("Revenue_Inactive").Visible = True
    .Shapes("Revenue_Active").Visible = False
    .Shapes("Units_Inactive").Visible = False
    .Shapes("Units_Active").Visible = True
        
    'visibility of Tab Contents
    .Shapes("Map_Chart_Sales_Revenue").Visible = False
    .Shapes("Line_Chart_Sales_Revenue").Visible = False
    .Shapes("Map_Chart_Sales_Units").Visible = True
    .Shapes("Line_Chart_Sales_Units").Visible = True
                
 End With
    
End Sub
question from:https://stackoverflow.com/questions/65872789/incorrect-parameter-vba-script

与恶龙缠斗过久,自身亦成为恶龙;凝视深渊过久,深渊将回以凝视…
Welcome To Ask or Share your Answers For Others

1 Reply

0 votes
by (71.8m points)
Sub Display_Tab_Sales_Units()

With ActiveSheet
.Shapes("Revenue_Inactive").Visible = True
.Shapes("Revenue_Active").Visible = False
.Shapes("Units_Inactive").Visible = False
.Shapes("Units_Active").Visible = True
.Shapes("Map_Chart_Sales_Revenue").Visible = False
.Shapes("Line_Chart_Sales_Revenue").Visible = False
.Shapes("Map_Chart_Sales_Units").Visible = True
.Shapes("Line_Chart_Sales_Units").Visible = True    
End With

End Sub

与恶龙缠斗过久,自身亦成为恶龙;凝视深渊过久,深渊将回以凝视…
OGeek|极客中国-欢迎来到极客的世界,一个免费开放的程序员编程交流平台!开放,进步,分享!让技术改变生活,让极客改变未来! Welcome to OGeek Q&A Community for programmer and developer-Open, Learning and Share
Click Here to Ask a Question

...