Hi-

When we write a macro in excel and open the file there is popup box which
asks the user to select "Enable Macro" or "Disable Macro". If the user
selects disable macro then the macro becomes inactive. Is there any code to
enable the macro when the workbook is opened and its enabled automatically
without giving an option to the user for selecting (Enable or Disable Macro)
from the popup box.

Regards,
Murali. G

This is based on the security level the user has selected. If the security
level is set to medium the confirmation message pops up..You can avoid this
confirmation message if you set the security level to low in
ToolsMacroSecurity. Changing this through VBA not easy for obvious
security reasons.

If this post helps click Yes
---------------
Jacob Skaria


"Murali G" wrote:

Hi-

When we write a macro in excel and open the file there is popup box which
asks the user to select "Enable Macro" or "Disable Macro". If the user
selects disable macro then the macro becomes inactive. Is there any code to
enable the macro when the workbook is opened and its enabled automatically
without giving an option to the user for selecting (Enable or Disable Macro)
from the popup box.

Regards,
Murali. G

Alternatively, you can write your excel program as an excel add-in


On May 22, 8:52*pm, Murali G <Murali
wrote:
Hi-

When we write a macro in excel and open the file there is popup box which
asks the user to select "Enable Macro" or "Disable Macro". *If the user
selects disable macro then the macro becomes inactive. Is there any code to
enable the macro when the workbook is opened and its enabled automatically
without giving an option to the user for selecting (Enable or Disable Macro)
from the popup box. *

Regards,
Murali. G