Thread: Macro Question?
View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.misc,microsoft.public.excel.programming,microsoft.public.excel.worksheet.functions
Bob Phillips[_6_] Bob Phillips[_6_] is offline
external usenet poster
 
Posts: 11,272
Default 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