Hide Enable/Disable Startup
 

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
------------------------------------------------------------------------
Zurn's Profile: http://www.excelforum.com/member.php...o&userid=14645
View this thread: http://www.excelforum.com/showthread...hreadid=513532

Hide Enable/Disable Startup
 

anybody an idea?


--
Zurn
------------------------------------------------------------------------
Zurn's Profile: http://www.excelforum.com/member.php...o&userid=14645
View this thread: http://www.excelforum.com/showthread...hreadid=513532

Hide Enable/Disable Startup
 

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 wrote:

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
------------------------------------------------------------------------
Zurn's Profile: http://www.excelforum.com/member.php...o&userid=14645
View this thread: http://www.excelforum.com/showthread...hreadid=513532

--

Dave Peterson

Hide Enable/Disable Startup
 

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

--
Zur
-----------------------------------------------------------------------
Zurn's Profile: http://www.excelforum.com/member.php...fo&userid=1464
View this thread: http://www.excelforum.com/showthread.php?threadid=51353

Hide Enable/Disable Startup
 

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

Zurn wrote:

I'm aware of that...

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

Evreything is possible with VBA...not?

Greets,
Zurn

--
Zurn
------------------------------------------------------------------------
Zurn's Profile: http://www.excelforum.com/member.php...o&userid=14645
View this thread: http://www.excelforum.com/showthread...hreadid=513532

--

Dave Peterson