Hide Enable/Disable Macro pop-up when file opens

[steve]

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?

 

[Bernie Deitrick]

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]

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





.

 

[Gord Dibben]

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