Adding Menu Buttons

's Computer Specifications

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

's Computer Specifications

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 <(E-Mail Removed)>
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

's Computer Specifications

Hey Gord,

That is what I needed,

Thank you.

-Minitman

On Tue, 01 Jul 2008 14:17:52 -0700, Gord Dibben <gorddibbATshawDOTca>
wrote:

>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 <(E-Mail Removed)>
>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

's Computer Specifications

Good luck with the project.

Gord

On Tue, 01 Jul 2008 17:12:09 -0500, Minitman <(E-Mail Removed)>
wrote:

>Hey Gord,
>
>That is what I needed,
>
>Thank you.
>
>-Minitman
>
>
>On Tue, 01 Jul 2008 14:17:52 -0700, Gord Dibben <gorddibbATshawDOTca>
>wrote:
>
>>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 <(E-Mail Removed)>
>>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

's Computer Specifications

Thanks.

-Minitman

On Tue, 01 Jul 2008 15:21:54 -0700, Gord Dibben <gorddibbATshawDOTca>
wrote:

>Good luck with the project.
>
>Gord
>
>On Tue, 01 Jul 2008 17:12:09 -0500, Minitman <(E-Mail Removed)>
>wrote:
>
>>Hey Gord,
>>
>>That is what I needed,
>>
>>Thank you.
>>
>>-Minitman
>>
>>
>>On Tue, 01 Jul 2008 14:17:52 -0700, Gord Dibben <gorddibbATshawDOTca>
>>wrote:
>>
>>>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 <(E-Mail Removed)>
>>>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

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
position of menu box relative to menu bar buttons	=?Utf-8?B?R3JhaGFtMTAwMA==?=	Microsoft Word Document Management	0	15th Sep 2007 02:34 PM
Adding buttons to a new menu bar	Greegan	Microsoft Excel Worksheet Functions	1	7th Apr 2006 07:55 AM
Add Buttons to Menu - Buttons don't stay	=?Utf-8?B?SmFzb24gUnlvbg==?=	Microsoft Word Document Management	5	28th Sep 2005 04:20 AM
Adding & removing menu buttons	R. Choate	Microsoft Excel Programming	4	3rd Jan 2005 03:49 AM
problem adding button to an EXISTING dropdown menu on a Worksheet Menu Bar	Karen P	Microsoft Excel Worksheet Functions	3	29th Oct 2003 12:42 AM