Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc,microsoft.public.excel.programming,microsoft.public.excel.worksheet.functions
|
|||
|
|||
Macro Question?
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 |
#2
Posted to microsoft.public.excel.misc,microsoft.public.excel.programming,microsoft.public.excel.worksheet.functions
|
|||
|
|||
Macro Question?
Have you left something out of your question?
"Greg B" wrote: 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 |
#3
Posted to microsoft.public.excel.misc,microsoft.public.excel.programming,microsoft.public.excel.worksheet.functions
|
|||
|
|||
Macro Question?
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. |
#4
Posted to microsoft.public.excel.misc,microsoft.public.excel.programming,microsoft.public.excel.worksheet.functions
|
|||
|
|||
Macro Question?
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 "Greg B" wrote: 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. |
#5
Posted to microsoft.public.excel.misc,microsoft.public.excel.programming,microsoft.public.excel.worksheet.functions
|
|||
|
|||
Macro Question?
Or
Sub OpenMyForm() If ActiveWorkbook.Saved Then UserForm1.Show End If End Sub "gocush" /delete wrote in message ... 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 "Greg B" wrote: 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. |
#6
Posted to microsoft.public.excel.misc,microsoft.public.excel.programming,microsoft.public.excel.worksheet.functions
|
|||
|
|||
Macro Question?
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) "Greg B" wrote in message ... 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 |
#7
Posted to microsoft.public.excel.misc,microsoft.public.excel.programming,microsoft.public.excel.worksheet.functions
|
|||
|
|||
Macro Question?
Thank you everybody
Taken all tips Thanks again Greg |
#8
Posted to microsoft.public.excel.misc,microsoft.public.excel.programming,microsoft.public.excel.worksheet.functions
|
|||
|
|||
Macro Question?
Why not delete the first form after it has shown. Design your code to check
for its existence and show the second if the first does not exist. Of course the workbook would need to be saved after you delete the first form. http://www.cpearson.com/excel/vbe.htm -- Regards, Tom Ogilvy "Greg B" wrote in message ... Thank you everybody Taken all tips Thanks again Greg |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2007 Macro/VB Question DDE Question | Excel Worksheet Functions | |||
Macro Question | Excel Worksheet Functions | |||
Macro Question | Excel Worksheet Functions | |||
Macro Question | Excel Worksheet Functions | |||
Macro Help / Question | Excel Programming |