Changing Userform popup based on document name

[sassriverrat]

Trying to have 3 different userforms popup based on the document having three different names- basically I want a userform to popup when the document is the "template" then once it gets saved as "working" for the first time, a different userform will popup, then as it gets saved as again "archive ###" it will have a third user form popup when opening. Guessing this would be a series of If's.

thanks

 

[Momentman]

The IFS would surely work too

Something like a Select Case statement could be used

Sub UserformPopUp()
    Select Case NameofFile'Assuming you have extracted the anem of the file (as in Template, working e.t.c)
        Case "Template"
            Userform1.Show
        Case "Working"
            Userform2.Show
        Case "Archive"
            Userform3.Show
    End Select
End Sub

 

[sassriverrat]

What I had is below. It is giving me a "424 Object Required" Error. What do I need to do? Or, how could I modify your code to make userform3 equal to the archive section, because the "Archive" is a changing name- each time this workbook is finished and archived, it has a "#""L or B" and then "Name" - "Name"

thanks!

Private Sub Workbook_Open()
If ActiveWorkbook.Name = "Master Voyage Report.xlsm" Then
    Userform1.Show
    Applications.Visible = False
ElseIf Activework.Name = "Current Voyage Report.xlsm" Then
    Userform2.Show
    Applications.Visible = False
Else: Userform3.Show
    Applications.Visible = False
End If
End Sub

 

[Momentman]

Where are you getting the error? on what line, maybe the

Activework.Name

which should be4

Activeworkbook.Name

 

[sassriverrat]

Ahh yes that would be a problem- but no- the error is coming from "Applications.Visible = False"

 

[Momentman]

Ahh yes that would be a problem- but no- the error is coming from "Applications.Visible = False"

Thats because there's no Applications object, it is APPLICATION, without the "s"