Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Toolbar - Button Won't Stay
Hi,
I created a macro MrgCtr, it's in my Personal.xls. I have one custom toolbar named KTools. I added a button for this macro to this toolbar. I attached the toolbar to Personal.xls, I attached it to another file I use all the time. The button leaves whenever I quit Excel. I have added buttons before and this hasn't happened. I'm stumped. TIA |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Toolbar - Button Won't Stay
I think your life will be lots easier if you create that toolbar when the
workbook opens and destroy it when the workbook closes. Some references if you want to look at that option: For additions to the worksheet menu bar, I really like the way John Walkenbach does it in his menumaker workbook: http://j-walk.com/ss/excel/tips/tip53.htm Here's how I do it when I want a toolbar: http://www.contextures.com/xlToolbar02.html (from Debra Dalgleish's site) And if you use xl2007: If you want to learn about modifying the ribbon, you can start at Ron de Bruin's site: http://www.rondebruin.nl/ribbon.htm http://www.rondebruin.nl/qat.htm -- For macros for all workbooks (saved as an addin) or http://www.rondebruin.nl/2007addin.htm In xl2007, those toolbars and menu modifications will show up under the addins. Karin wrote: Hi, I created a macro MrgCtr, it's in my Personal.xls. I have one custom toolbar named KTools. I added a button for this macro to this toolbar. I attached the toolbar to Personal.xls, I attached it to another file I use all the time. The button leaves whenever I quit Excel. I have added buttons before and this hasn't happened. I'm stumped. TIA -- Dave Peterson |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Toolbar - Button Won't Stay
Dave,
Thank you - works great! Is there anyway to attach the toolbar to the toolbar area instead of having it float on the worksheet? TIA "Dave Peterson" wrote: I think your life will be lots easier if you create that toolbar when the workbook opens and destroy it when the workbook closes. Some references if you want to look at that option: For additions to the worksheet menu bar, I really like the way John Walkenbach does it in his menumaker workbook: http://j-walk.com/ss/excel/tips/tip53.htm Here's how I do it when I want a toolbar: http://www.contextures.com/xlToolbar02.html (from Debra Dalgleish's site) And if you use xl2007: If you want to learn about modifying the ribbon, you can start at Ron de Bruin's site: http://www.rondebruin.nl/ribbon.htm http://www.rondebruin.nl/qat.htm -- For macros for all workbooks (saved as an addin) or http://www.rondebruin.nl/2007addin.htm In xl2007, those toolbars and menu modifications will show up under the addins. Karin wrote: Hi, I created a macro MrgCtr, it's in my Personal.xls. I have one custom toolbar named KTools. I added a button for this macro to this toolbar. I attached the toolbar to Personal.xls, I attached it to another file I use all the time. The button leaves whenever I quit Excel. I have added buttons before and this hasn't happened. I'm stumped. TIA -- Dave Peterson |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Toolbar - Button Won't Stay
You can change this portion:
.Position = msoBarFloating to .Position = msoBarTop or .Position = msoBarBottom Personally, I like to float it in the window. The user can move it to where they want, but I figure that they'll notice that it was added! Karin wrote: Dave, Thank you - works great! Is there anyway to attach the toolbar to the toolbar area instead of having it float on the worksheet? TIA "Dave Peterson" wrote: I think your life will be lots easier if you create that toolbar when the workbook opens and destroy it when the workbook closes. Some references if you want to look at that option: For additions to the worksheet menu bar, I really like the way John Walkenbach does it in his menumaker workbook: http://j-walk.com/ss/excel/tips/tip53.htm Here's how I do it when I want a toolbar: http://www.contextures.com/xlToolbar02.html (from Debra Dalgleish's site) And if you use xl2007: If you want to learn about modifying the ribbon, you can start at Ron de Bruin's site: http://www.rondebruin.nl/ribbon.htm http://www.rondebruin.nl/qat.htm -- For macros for all workbooks (saved as an addin) or http://www.rondebruin.nl/2007addin.htm In xl2007, those toolbars and menu modifications will show up under the addins. Karin wrote: Hi, I created a macro MrgCtr, it's in my Personal.xls. I have one custom toolbar named KTools. I added a button for this macro to this toolbar. I attached the toolbar to Personal.xls, I attached it to another file I use all the time. The button leaves whenever I quit Excel. I have added buttons before and this hasn't happened. I'm stumped. TIA -- Dave Peterson -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
toolbar button | Excel Discussion (Misc queries) | |||
floating toolbar to stay put | Excel Discussion (Misc queries) | |||
Ex 2K Standard Toolbar won't stay hidden | Excel Discussion (Misc queries) | |||
XPSP4, Excel 02, custom button to SEND MESSAGE wont stay on toolb | Excel Discussion (Misc queries) | |||
Why does my autofill stay on after I release the mouse button? | Excel Discussion (Misc queries) |