I have a desk top short cut set up so the users can go directly to the spreedsheet. But I am attempting to keep users from the spreedsheet and go directly to the userform. The below code takes them to spreedsheet 3, how do I change this so they go directly to the user form.
I have attached my active workbook. You will also note that I have disabled the X so they must use the Exit button.
Thanks for any help all is appreciated!
Private Sub Workbook_Open()
Worksheets("Sheet3").Activate
frmINVENTORY.Show
End Sub
Bookmarks