On a command button in a userform, I have this code to open another workbook:
Now I want to activate the sheet called "HDM Anvils" in the workbook we just opened.![]()
Private Sub CommandButton4_Click() Dim MyWb1 As Workbook Workbooks.Open ("C:\pro\anvils.xls") Set MyWb1 = ActiveWorkbook End Sub
Thanks for any help.
Bookmarks