Custom Toolbar does not display all buttons

P

Pete

My custom Toolbar works fine on my PC at work which it was created on
and saved in the workbook. When I open the workbook on another PC only
2 of the three buttons display, and on another PC only one button is
shown.

I automatically display the toolbar when the sheet opens and turn off
the toolbat when the workbook closes

Any idea's.?

cheers
Pete
 
G

GS

Pete formulated on Monday :
My custom Toolbar works fine on my PC at work which it was created on
and saved in the workbook. When I open the workbook on another PC only
2 of the three buttons display, and on another PC only one button is
shown.

I automatically display the toolbar when the sheet opens and turn off
the toolbat when the workbook closes

Any idea's.?

cheers
Pete

Post your code!
 
D

Dave Peterson

My guess is that Jan Karel Pieterse's article will explain your problem and
provide a fix:

http://www.jkp-ads.com/Articles/DistributeMacro04.asp

But this is what I'd do:

Saved from a previous post:

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)

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top