| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Adding Menu Buttons
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Adding Menu Buttons
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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Adding Menu Buttons
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 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 |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Adding Menu Buttons
Good luck with the project.
Gord On Tue, 01 Jul 2008 17:12:09 -0500, Minitman 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 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 |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Adding Menu Buttons
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 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 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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Adding buttons to a new menu bar | Excel Worksheet Functions | |||
| Adding Sub Menu Item to Current Custom Menu | Excel Programming | |||
| Adding & removing menu buttons | Excel Programming | |||
| Adding a menu item right click menu when clicking on a single. | Excel Programming | |||
| Adding menu to the mouse right click pop-up menu | Excel Programming | |||
Hybrid Mode
