Hi Dave,

I have used your method to add a custom toolbar and it is awesome. I have
one problem, however, in that the macros assigned to the buttons (which work
independently) now do not function properly.

There are three macros which are essentially the same: they insert a row and
add text to column c; indent, color, font.

Can you please help me to determine why the macros are not working with the
toolbar?

--
- thank you
penGuin_1


"Dave Peterson" wrote:

Just to add to Jim's reply.

Here's how I create that toolbar on the fly:
http://groups.google.co.uk/groups?th...5B41%40msn.com

If you want to add items to the worksheet menu bar, you can use John
Walkenbach's menumaker:
http://j-walk.com/ss/excel/tips/tip53.htm

jpw48 wrote:

Hi
I have created a series of Macros in excel, and have alocated them to a
custom toolbar I have made. Is there a way which I can save the toolbar and
macros with the excel spreadsheet, so tht the whole set-up can be used on a
seperate computer?

--

Dave Peterson