MS Office Forum

Ask Question   UnAnswered
Home » Forum » MS Office       RSS Feeds

Global Macro ?

  Asked By: Binge    Date: Oct 24    Category: MS Office    Views: 1595

Is it possible to make a macro have global scope?
I've developed a macro for a specific use and now want to create
several spinoffs.
I'd like to be able to have changes to the global macro propagate
across all the child files using the macro.
Is this possible?



2 Answers Found

Answer #1    Answered By: Marnia Mian     Answered On: Oct 24

Not sure if I am understanding the question correctly, but I think
what you want to look at is creating an add-in -- basically, a VBA
project that can be easily turned on/off with all EXCEL workbooks via
the > Tools > Add-Ins menu option.

Answer #2    Answered By: Ayaz Hashmi     Answered On: Oct 24

Yeah, it is possible. To perform the same, you should write this macro  in
"Personal.xls" workbook.

Didn't find what you were looking for? Find more on Global Macro ? Or get search suggestion and latest updates.