displaying a userform after a sheet is selected

[forest1959]

Hi

I'm trying to write some code that will firstly, open a specific worksheet, then display a userform.. Anything i have tried so far displays the user form before opening the worksheet.

the code i am using is below.

Is there something simple i'm missing that would delay the displaying of the userform until the user had visibility of the "Technique" worksheet.

Many Thanks

Sub SaveWithVariableFromCell()


    Application.ScreenUpdating = False
    
    Sheets("Technique").Visible = True
    Sheets("Calculator").Visible = False
    Sheets("Schedule").Visible = False
    Sheets("User Guide").Visible = False
    Sheets("Home").Visible = False
    Sheets("Technique").Select
    
    UserForm2.Show


    Application.ScreenUpdating = True    
    
End Sub

 

[Fluff]

Try turning ScreenUpdating back on, before showing the userform

 

[forest1959]

Try turning ScreenUpdating back on, before showing the userform

Perfect, thank you very much.

 

[Fluff]

You're welcome & thanks for the feedback