• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 240
  • Last Modified:

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
0
bsharath
Asked:
bsharath
1 Solution
 
KCTSCommented:
You need to store in in the the book.xlt template on in a file in the XLSTART folder. see http://office.microsoft.com/en-us/excel/HA010872961033.aspx
0
 
Patrick MatthewsCommented:
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
0

Featured Post

Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now