Link to home
Start Free TrialLog in
Avatar of bsharath
bsharathFlag for India

asked on

How can i have all macro in a file and use them when ever required.


Hi,

How can i have all macro in a file and use them when ever required.When ever i open a new excel or a existing excel these macros should be seen there and i should be able to run them.
Regards
Sharath
ASKER CERTIFIED SOLUTION
Avatar of Brian Pierce
Brian Pierce
Flag of United Kingdom of Great Britain and Northern Ireland image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Hello bsharath,

Be advised that the linked page KCTS points to shows how to create a Personal.xls file,
which is what you appear to need.  I would advise NOT storing the macros in a book.xlt
template.

Regards,

Patrick