Macro Question?

G

Greg B

Is it possible to have excel change a macro after the first use? What I mean
is when once you save the workbook I have created a certain splash screen
will show instead of the other one?


Thanks in advance


Greg
 
G

Greg B

No, I am asking is it possible to cancel a userform that starts on loading a
form for the first time and is it possilble to make a macro to stop this
userform from loading again.
 
G

gocush

Does something like this work:

Option Explicit

Sub OpenMyForm()
If Not Range("A1") = "Don't Open" Then
UserForm1.Show
End If
End Sub


With the userform code:

Private Sub UserForm_Initialize()

Range("A1") = "Don't Open"

End Sub
 
M

Mohamed Shafiee

Or

Sub OpenMyForm()
If ActiveWorkbook.Saved Then
UserForm1.Show
End If
End Sub
 
B

Bob Phillips

Greg,

I would create a public Boolean variable, and set that after first run, and
when displaying the splash screen, check its status to see which to display.

--

HTH

RP
(remove nothere from the email address if mailing direct)
 
Top