Run Macro After User Enables Macros

[SP Brian]

I know that you can enable a workbook to run a macro upon opening, but that doesn't work if a user of the workbook doesn't have macros automatically enabled... at least that's how it works from my understanding.

With that in mind, how would I create a macro to run immediately after a user enables Macros and ActiveX?

[Palmetto]

How would I create a macro to run immediately after a user enables Macros and ActiveX?

Either place the code or call the sub within the module named "ThisWorkbook" and use the workbook_open event.

Please Login or Register  to view this content.

[SP Brian]

Could you explain more, please? I am unfamiliar with programming.

[Palmetto]

First, a user must the macro security setting to Medium (pre-2007 versions) or "Disable all macros with notification for 2007.

Unless the macro security is set to these options, users will not be prompted to enable macros

As for creating macros, the easiest way to get started is to use the macro recorded built in to Excel, then post the code to the forum and provide a clear explanation of what you are trying to do, accompanied by a sample workbook that illustrates the desired results.

For macros to run automatically, the code must either reside in (or the macro called) the module named "Thisworkbook" using the event know as the workbook_open event.

All macro-enable workbooks have a module for the workbook and worksheets. There is also a standard modules and class modules that can be inserted when needed.

The question of creating macros and modules can be lengthy. I suggest you record a macro, search the forum for specific questions related to your task and follow my suggestion above about posting code/workbooks for further help.