Excel vba user form- open directly to user form not worksheet

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

Attempted that but it still goes to sheet 3. A security warning shows at the top of the spreadsheet (macros have been disabled choose options etc.. Could this be the hold up?

I just disabled the Security alert macro but it still goes to sheet 3.

Sorry, here it is with changes you suggested.

Nori,

My attempt has failed. Please tell me what I did wrong. Thank you!

Please advise as to what can be removed an where to add Application.Visible to False

Please Login or Register  to view this content.

Norie,

Attempted that but I must have screwed it up. Also tried...

Sub Auto_Open()
Userform1.show
End Sub

No luck!

Still going to sheet 3 on the load up

Sorry not a programmer had no idea where that code was to go. So I deleted it from the userform and added to "ThisWorkbook". Sad to say it still is not working. Had high hopes though!

Could there be something in the Trust center that is stopping it from going straight to the user form?

It opens to sheet 3 then I have to click on the Security alert macro "enable this content" to get the Userform to open. If I change the macro to not show that alert it just goes straight to sheet 3 and the user has no way to get to the Userform.

Current setting is

Disable all macros with notification (the user can get to the Userform when they click on options and enable this content.

If I change it to Disable all macros without notification the user can't get to the Userform.

Yes, you are a genius! How do I access the code, now I do have a backup that I have not enabled all macros so I can make an updates to that but I thought there may be a way for me to access this one........