barry houdini
MrExcel MVP
- Joined
- Mar 23, 2005
- Messages
- 20,825
I probably shouldn't admit this......
I use personal.xls a little like Joe describes. All users in my office have a copy. Each macro therein simply calls a routine which is centrally stored, so if I need to change the code I can do it once only. Of course if I want to add new procedures I need to change each users personal.xls.....but that doesn't happen very often.
It didn't work that way before last year but that was the only way I could make it happen with 2007. Never created an add-in......
Piggy Bank is my favorite, everbody has one.....

I use personal.xls a little like Joe describes. All users in my office have a copy. Each macro therein simply calls a routine which is centrally stored, so if I need to change the code I can do it once only. Of course if I want to add new procedures I need to change each users personal.xls.....but that doesn't happen very often.
It didn't work that way before last year but that was the only way I could make it happen with 2007. Never created an add-in......
.....a Piggie bank........on my toolbar......
Piggy Bank is my favorite, everbody has one.....
Last edited: