You don't.

Create the Toolbar buttons when you open/activate the workbook.

See Debra Dalgleish's site for creating a Toolbar from code.

http://www.contextures.on.ca/xlToolbar02.html


Gord Dibben MS Excel MVP


On Tue, 01 Jul 2008 15:49:41 -0500, Minitman
wrote:

Greetings,

I have a worksheet with three CommandButtons on the sheet.

How do I move them from the spread sheet area to the menu bar so they
are available to other worksheets?

Any help will be appreciated.

-Minitman