Buttons

[Lodewijk]

In Excel I have a worksheet with buttons above each sheet. These buttons
active macros.
In my own sheet a made it work, but when someone else opens the sheet,
buttons do not apaer. How can i make that happen?

 

[Gord Dibben]

Were the buttons placed onto a Toolbar manually by dragging them there?

If so, the toolbar and menu customization/settings are saved in your *.XLB
file, which is on your computer and not accessible to others.

You could always export your *.xlb file to others, but this would destroy
their customizations.

The best way to set up customizations is to create the buttons/toolbars/menus
through VBA so they appear when the workbook is opened.

Some instructions and code here.........

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dno97ta/html/ofcmdbar.asp

Also John Walkenbach's downloadable MENUMAKR.XLS is a handy tool for
customizing menus.

Find it and sample code for creating "on the fly" toolbars.

http://www.j-walk.com/ss/excel/tips/commandbars.htm

Gord Dibben Excel MVP