Adding Menu Buttons

[Minitman]

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

 

[Gord Dibben]

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

 

[Minitman]

Hey Gord,

That is what I needed,

Thank you.

-Minitman

 

[Gord Dibben]

Good luck with the project.

Gord

Hey Gord,

That is what I needed,

Thank you.

-Minitman

 

[Minitman]

Thanks.

-Minitman

Good luck with the project.

Gord