Hide Enable/Disable Startup

[Zurn]

Hey,

when opening an Excel workbook containing macros...the Excel prompts
always for Enable of disable the macros.

Is there a way to programm this so that this message doesn't appear and
the macros are run (so virtually push enable button)?


Zurn

 

[Zurn]

anybody an idea?

 

[Dave Peterson]

This is a security setting that helps protect the user from bad stuff that could
be sent in macros.

It wouldn't be very secure if there was a way to disable the user's choice.

 

[Zurn]

I'm aware of that...

But does this mean there doesn't exist the possibilitie t
automatically enable macros?

Evreything is possible with VBA...not?


Greets,
Zur

 

[Dave Peterson]

Not if the user chooses not to allow your macro to even start.