VBA Error Code '5' Invalid procedure call or argument

[LH2022]

Hi, I'm hoping someone can help.

I don't have a lot of experience with creating macros on Excel but I have been following a tutorial to create tabs in a sheet. The idea is when someone selects one of the tabs for example, sale by revenue/sales by units, the relevant graph will appear. The code which I have been given is as below and it works for the guy in the tutorial but not for me and I don't know why!

I hope someone can help me work out where I am going wrong!

Sub Display_Tab_Sales_Revenue()

    With ActiveSheet
   
        'Visibility of Tab Buttons
        .Shapes("Units_Inactive").Visible = True
        .Shapes("Units_Active").Visible = False
        .Shapes("Revenue_Inactive").Visible = True
        .Shapes("Revenue_Active").Visible = False
       
        'Visibility of Tab Contents
        .Shapes("Line_Chart_Revenue").Visisble = True
        .Shapes("Line_Chart_Unit").Visible = False

    End With
           
End Sub

Sub Display_Tab_Sales_Units()

    With ActiveSheet

        'Visibility of Tab Buttons
        .Shapes("Units_Inactive").Visible = False
        .Shapes("Units_Active").Visible = True
        .Shapes("Revenue_Inactive").Visible = False
        .Shapes("Revenue_Active").Visible = True
       
        'Visibility of Tab Contents
        .Shapes("Line_Chart_Reveue").Visible = False
        .Shapes("Line_Chart_Unit").Visible = True
       
    End With

 

[RoryA]

You have a typo here:

.Shapes("Line_Chart_Revenue").Visisble = True

 

[LH2022]

You have a typo here:

.Shapes("Line_Chart_Revenue").Visisble = True

Oh jeez! I have updated this and ran it again and now I get the following

"System Error &H80070057 (-2147024809)"

 

[RoryA]

That means you don't have a shape with the specified name. Double check them carefully.

 

[LH2022]

That's worked! Amazing, thank you!

 

[RoryA]

Glad we could help.

Welcome to the forum, by the way!