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

Macros in XlStart directory

I have created a macro and assigned it into a button on a toolbar.  I wish to have this macro available to me anytime.  Problem is I saved it in the XlStart folder, but everytime I launch Excel, it opens the workbook.  I want the macro to be available, but I do not want the workbook to be seen.
0
mak345
Asked:
mak345
1 Solution
 
mvidasCommented:
mak345,

Save the workbook as an add-in, close the workbook, then enable the add-in.  You will have to change the macro reference on the toolbar button to reflect the add-in.  Keep in mind while doing this that although the macro names won't show up on the macro listing, if you manually type in the macro name it will work.  You may have to qualify it like:
WORKBOOK.XLA!MacroName

Another way would be to make the workbook hidden (Window / Hide), and you won't see the workbook when it is loaded.  That is what excel does with your PERSONAL.XLS file.

Matt
0

Featured Post

Hire Technology Freelancers with Gigs

Work with freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely, and get projects done right.

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