A
Adrian Nelson
Sorry to cross-post, not having much luck in excel.programming!
Hi,
We have a large application, excel based with a load of VBA.
Currently there's a macro that shows a "splashscreen" when the sheet is
opened, pauses for 10 seconds and then closes using a killform. Problem is,
it's the only macro in the whole app, which means that new users opening the
sheet get the Microsoft nag about macro's and not allowing the sheet to open
for something really very cosmetic.
I wonder if anyone has any ideas about how we can transform from a macro to
some VBA to kill this splashscreen? The only ways we can think of are more
macro's! The user can press a button (doesn't have to be timed).
Any thoughts, ideas or comments very appreciated.
Adrian
Hi,
We have a large application, excel based with a load of VBA.
Currently there's a macro that shows a "splashscreen" when the sheet is
opened, pauses for 10 seconds and then closes using a killform. Problem is,
it's the only macro in the whole app, which means that new users opening the
sheet get the Microsoft nag about macro's and not allowing the sheet to open
for something really very cosmetic.
I wonder if anyone has any ideas about how we can transform from a macro to
some VBA to kill this splashscreen? The only ways we can think of are more
macro's! The user can press a button (doesn't have to be timed).
Any thoughts, ideas or comments very appreciated.
Adrian