• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Macros OUTSIDE or INDEPENDENT of particular Excel File(s)

S

saeed

New Member
Good Day,


Is it possible to save VBA macros as independent, external files? There are many operations common to many files, many of them non-recurring; for instance performing certain formatting.


For various reasons, file size etc, I wish to keep these macros outside of any particular Excel file; invoking and running them as needed, then closing them.
 
Saeed


Firstly, Welcome to the Chandoo.org forums


Look up the use of Personal.xls/x files either here or on the internet.


Maybe start here: http://office.microsoft.com/en-us/excel-help/deploy-your-excel-macros-from-a-central-file-HA001087296.aspx
 
Hello Hui,


Sorry for taking a while to get back.

This is excatly what I was looking for!


Many Thanks.


Saeed
 
You must log in or register to reply here.
Back
Top