Changing Macro Folder

[JDub]

I have created macro’s that I shared with my colleagues. However, in some
offices, they do not have the same end folder as I have and cannot save/use
the macro’s and toolbar associated with the macros. For example, my Macro’s
are save with …Enduser and in the other office it is …All Users. Is there an
easy way to change the folder location without having to create the macro’s
on my colleagues computer?

Thanks,
Josh

 

[Dave Peterson]

I think you'l have many fewer problems if you create the toolbar on the fly when
the workbook opens (and destroy that toolbar when the workbook closes).

For additions to the worksheet menu bar, I really like the way John Walkenbach
does it in his menumaker workbook:
http://j-walk.com/ss/excel/tips/tip53.htm

Here's how I do it when I want a toolbar:
http://www.contextures.com/xlToolbar02.html
(from Debra Dalgleish's site)