It may seem that creating the toolbar is more complex--until you have to
reassign all the icons to a different location.

Karin wrote:

Dave, that toolbar link makes things much more complicated, it seems to me,
than necessary. I just right click in the toolbar area, choose customize and
off I go. I then have a toolbar I can click on or off whenever I want
without writing code.

"Karin" wrote:

Dave, I want the toolbar to always be available...and I'm no programmer.
The macros were auto recorded. I know how to go into VB, to copy and paste
macros, to import/export modules, but to create code as you suggest is
probably beyond me. That said, I'll take a look at your links and see what I
learn.

"Dave Peterson" wrote:

Your life will become much simpler if you include code to create the toolbar
when the workbook is opened and include code to destroy the toolbar when the
workbook is closed.

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)

Karin wrote:

I've created a custom toolbar with macros attached. I figured out how to
copy the personal.xls and excel.xlb files to a co-workers computer. The
problem is that the macros have a path that leads to a directory with my name
on it. Where can I find the location of the path attached to the
macro/toolbar and change it to her path?

--

Dave Peterson


--

Dave Peterson