I need to distribute macros to users (Excel). New macros will be added from time to time and adjustments will be made to current coding. I got two suggestions from this board:
1-Save into a workbook and have users save in the same directory as "personal.xls" (so it wouldn't overwrite the user's personal macro directory).
2-Create an add-in.
I decided to go with #1. This appeared to be a great solution.
I saved macros that were completely coded into a separate workbook. In this workbook I created a short "instruction sheet" and a command button that automatically copies it to the
office/xlstart directory. This seemed like the perfect solution, as updated ones could be sent and overwrite the old macro workbook for updating.
Problem:
--When I tested this, whenever Excel starts, this macro workbook opens and the instruction sheet/command button appears.
I'm not that familiar with add-ins, although the end result would be nice and I could create some custom menus, etc. Right now the current solution seems the easiest to implement.
**Is there something I can do so that this workbook opens "behind the scenes" like personal.xls?**
Any suggestions on how YOU would do this would be appreciated.
Thanks in advance!
1-Save into a workbook and have users save in the same directory as "personal.xls" (so it wouldn't overwrite the user's personal macro directory).
2-Create an add-in.
I decided to go with #1. This appeared to be a great solution.
I saved macros that were completely coded into a separate workbook. In this workbook I created a short "instruction sheet" and a command button that automatically copies it to the
office/xlstart directory. This seemed like the perfect solution, as updated ones could be sent and overwrite the old macro workbook for updating.
Problem:
--When I tested this, whenever Excel starts, this macro workbook opens and the instruction sheet/command button appears.
I'm not that familiar with add-ins, although the end result would be nice and I could create some custom menus, etc. Right now the current solution seems the easiest to implement.
**Is there something I can do so that this workbook opens "behind the scenes" like personal.xls?**
Any suggestions on how YOU would do this would be appreciated.
Thanks in advance!
