View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Dave Peterson Dave Peterson is offline
external usenet poster
 
Posts: 35,218
Default Changing Macro Folder

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)

JDub wrote:

I have created macros 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 macros and toolbar associated with the macros. For example, my Macros
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 macros
on my colleagues computer?

Thanks,
Josh


--

Dave Peterson