G
gigabyteconsulting
I want to add a macro we created to users machines without having to modify
the book.xlt template. I have noticed that the XLSTART folder does not work
like the STARTUP folder for word. The only way that I have been able to get
this to work is to hide the page in the workbook with the macro, name it to
personal.xls and save it to the xlstart folder. This way the default
template opens and the user can access the macro from the Tools --> Macros
list but the name of the macro is prefaced with personal.xls.
Is this the only way of adding Macros without modifying the base template?
If so is there a way to have Excel not preface the macro name with
personal.xls?
Any help would be appreciated.
the book.xlt template. I have noticed that the XLSTART folder does not work
like the STARTUP folder for word. The only way that I have been able to get
this to work is to hide the page in the workbook with the macro, name it to
personal.xls and save it to the xlstart folder. This way the default
template opens and the user can access the macro from the Tools --> Macros
list but the name of the macro is prefaced with personal.xls.
Is this the only way of adding Macros without modifying the base template?
If so is there a way to have Excel not preface the macro name with
personal.xls?
Any help would be appreciated.