S
Solutions Manager
I am moving a bunch of macros to a personal.xlsb worksheet so that I can make
existing worksheets macro-free. In these worksheets, Each of these
worksheets, has the same Autpen macro that runs through a series of steps.
I need this same macro to run whenever a user opens any excel file.
I don't need help testing the file being opened, I just need to know how to
trigger the macro stored in personal.xlsb each time a user opens any excel
file.
How can I make this macro run each time a user opens a workbook? This macro
is saved in my personal.xlsb file and I cannot seem to find a way to make the
macro run each time I open a workbook.
existing worksheets macro-free. In these worksheets, Each of these
worksheets, has the same Autpen macro that runs through a series of steps.
I need this same macro to run whenever a user opens any excel file.
I don't need help testing the file being opened, I just need to know how to
trigger the macro stored in personal.xlsb each time a user opens any excel
file.
How can I make this macro run each time a user opens a workbook? This macro
is saved in my personal.xlsb file and I cannot seem to find a way to make the
macro run each time I open a workbook.