UserForm to deactivate after first use

[harveya915]

I have a UserForm that pops up when the Sheet is opened for the first time. The UserForm only contains instructions and an "OK" button that makes the UserForm unload. The only problem now is that the UserForm will be popping up every time the sheet is opened.
Is there a way for the User Form to only pop up the first time the sheet is opened?

 

[My Aswer Is This]

Show Me the script you are now using.

 

[ZVI]

Static boolean flag can be used, something like this:

Private Sub Worksheet_Activate()
  Static IsOpen As Boolean
  If IsOpen Then Exit Sub
  UserForm1.Show
  IsOpen = True
End Sub

 

[harveya915]

Well...For the Workbook I have:

Private Sub Workbook_Open()
UserForm1.Show
End Sub

For the UserForm I have:

Private Sub CommandButtion1_Click()
Unload UserForm1
End Sub

Hope this is what you were asking for.

 

[harveya915]

Static boolean flag can be used, something like this:

Private Sub Worksheet_Activate()
  Static IsOpen As Boolean
  If IsOpen Then Exit Sub
  UserForm1.Show
  IsOpen = True
End Sub

I do apologize, but I'm not good at this, I'm very new at this. Would you be able to tell me where exactly do I put this code?

 

[ZVI]

I have a UserForm that pops up when the Sheet is opened for the first time.

Do you mean Workbook is opened for the first time?

 

[harveya915]

yes

 

[ZVI]

Replace the previous code of Workbook_Open by this one:

Private Sub Workbook_Open()
  If GetSetting(AppName:="HarveyaApp", Section:="Startup", Key:="Ok", Default:="0") = "0" Then
    SaveSetting AppName:="HarveyaApp", Section:="Startup", Key:="Ok", setting:="1"
    UserForm1.Show
  End If
End Sub

 

[ZVI]

And just for the debugging purpose, this code will add one more popup ability:

Sub RestorePopUp()
  DeleteSetting AppName:="HarveyaApp", Section:="Startup", Key:="Ok"
End Sub

 

[mikerickson]

I would do it slightly differently.
I would write a ShowInstructions sub, and have that called from the (one time) workbook Open event.
That way, the user could look at the instructions whenever they wanted (by calling ShowInstructions), but it would be forced on them only once.