Hide Enable/Disable Macro pop-up when file opens

For MS Excel files that contain macros, when the file is
opened, a standard pop-up window shows three buttons for
the user to select: "Enable" or "Disable" or "More Info".

In some instances, users select disable, and the macros I
created do not work in the file.

Is there VB code written to hide this window and to have
the macros automatically enable without giving the user an
option to disable?

Steve,

No. That behavior depends on their macro security setting, which you cannot
change. You could have a sheet that has "You should enable macros!" on it,
that you have as the default sheet, and that you hide with the workbook open
macro, so that if the macros are enabled the user only sees the sheet flash
by.

HTH,
Bernie
MS Excel MVP


"steve" <[email protected]> wrote in message
news:[email protected]...
> For MS Excel files that contain macros, when the file is
> opened, a standard pop-up window shows three buttons for
> the user to select: "Enable" or "Disable" or "More Info".
>
> In some instances, users select disable, and the macros I
> created do not work in the file.
>
> Is there VB code written to hide this window and to have
> the macros automatically enable without giving the user an
> option to disable?

Thanks for the information and good suggestion.

>-----Original Message-----
>Steve,
>
>No. That behavior depends on their macro security
setting, which you cannot
>change. You could have a sheet that has "You should
enable macros!" on it,
>that you have as the default sheet, and that you hide
with the workbook open
>macro, so that if the macros are enabled the user only
sees the sheet flash
>by.
>
>HTH,
>Bernie
>MS Excel MVP
>
>
>"steve" <[email protected]> wrote in
message
>news:[email protected]...
>> For MS Excel files that contain macros, when the file is
>> opened, a standard pop-up window shows three buttons for
>> the user to select: "Enable" or "Disable" or "More
Info".
>>
>> In some instances, users select disable, and the macros
I
>> created do not work in the file.
>>
>> Is there VB code written to hide this window and to have
>> the macros automatically enable without giving the user
an
>> option to disable?
>
>
>.
>

steve

That would obviate the need for Macro Security so there would be no point in
Excel providing security from macro viruses.

Check out help on "Digital Certificates" to find out how to sign your
projects.

OR go to news group alt.virus.distribution for pointers.


Gord Dibben Excel MVP

On Tue, 12 Apr 2005 07:44:10 -0700, "steve"
<[email protected]> wrote:

>For MS Excel files that contain macros, when the file is
>opened, a standard pop-up window shows three buttons for
>the user to select: "Enable" or "Disable" or "More Info".
>
>In some instances, users select disable, and the macros I
>created do not work in the file.
>
>Is there VB code written to hide this window and to have
>the macros automatically enable without giving the user an
>option to disable?