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

the warning message is based on the security settting for each PC.

The security setting can be changed in the tool menu under options.

Select Security and then Macro Security.

You can set the setting to Low.



"Adrian Nelson" wrote:

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

the warning pertains to Excel 4 macros and VBA.

That said, it sounds like the code is VBA anyway - there really is no
distinction between macro and VBA. The terms are usually used
interchangeably.

--
Regards,
Tom Ogilvy


"Adrian Nelson" wrote:

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