If the macros haven't changed, then I don't know why there are different
results.

Maybe you should be more specific. Post the portion of code that doesn't work
the way it should and explain what it should be doing.

penGuin_1 wrote:

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


--

Dave Peterson