VB error when using workbook on different laptop

[redspanna]

Hi all

I have a Active X Combo box that provides user with a 'menu' to select an option from a drop down menu on the 'FRONT' worksheet on my workbook.
The VB code then runs according to what option is selected from the menu...

Private Sub FrontMenu_Change()

With Sheets("Front").Range("A1")
   Select Case .Value
       Case "Add Daily Sales"
           UserForm1.Show
       Case "View Data Log"
                Sheets("Data").Select
       Case "View Year Totals"
                Sheets("Financial Year").Select
       Case "View Dashboard"
                Sheets("Dashboard").Select
       Case "Copy Dashboard Report"
                Call Save_Monthly_Dashboard
       Case "Print Dashboard Report"
                Call Print_Dashboard
       Case "Yearly Dashboard"
               Sheets("Dashboard2").Select
       Case "End Of Month Report"
                UserForm2.Show
       Case "Year On Year Review"
                 Sheets("YOY").Select
       Case "Desktop Dashboard"
                 Call Desktop_Dashboard
      
   End Select
End With
FrontMenu.Value = "* Sales *"
End Sub

this works perfectly until I copy the entire workbook to a different Laptop
When this happens and the option of "Add Daily Sales" is selected I get an error box stating RUN TIME ERROR 76 PATH NOT FOUND and this part of the code is highlighted

 UserForm1.Show

The Userform is obvioulsy there because its working perfectly in the other version on another laptop

any ideas why this may be happeneing and suggstion to fix

Many thanks

 

[Fluff]

In the VB editor click on Tools, Options, General & select "Break in class module", Ok.
Then try running the code again.

 

[redspanna]

In the VB editor click on Tools, Options, General & select "Break in class module", Ok.
Then try running the code again.

Thats seems to have fixed it - thanks as always @Fluff

 

[Fluff]

You're welcome & thanks for the feedback.