Thanks very much guys. You have been very helpful.
Kind regards
Bugzee

"Dave Peterson" wrote:

This doesn't have anything to do with DLLs.

And since you're sharing with others, don't share a workbook named
personal.xls. Excel only allows one workbook with that name to be open in any
particular instance.

If the recipients have their own personal.xls workbook, then they'll have to
close that file and open yours.

Instead create a new utility workbook that contains all your macros. Name it
BugZeeUtils.xls and tell them to save it in a particular location on their
harddrive (like: C:\ExcelUtilities\bugzeeutils.xls

This file can have code that creates the button on the toolbar when it opens and
removes the button when it 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)

In xl2007, those toolbars and menu modifications will show up under the addins.

And if you use xl2007:

If you want to learn about modifying the ribbon, you can start at Ron de Bruin's
site:
http://www.rondebruin.nl/ribbon.htm
http://www.rondebruin.nl/qat.htm -- For macros for all workbooks (saved as an
addin)
or
http://www.rondebruin.nl/2007addin.htm

Bugzee wrote:

I am trying to get an Excel macro to run from any workbook by placing a
button on the menu bar. I do not know which DLL to include in the Public
Declaration. Can anyone advise me?
Thanks.
Bugzee

--

Dave Peterson