Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Save Macro and Custom Toolbar in Worksheet
I know I read about how you can save your custom macros and toolbars in a
specific worksheet instead of globally in your Excel environment. I can't find how to do this now. Any help would be appreciated. Thanks, Pat |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Save Macro and Custom Toolbar in Worksheet
I think....
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. Pat wrote: I know I read about how you can save your custom macros and toolbars in a specific worksheet instead of globally in your Excel environment. I can't find how to do this now. Any help would be appreciated. Thanks, Pat -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Lost new custom toolbar button with its macro | Excel Discussion (Misc queries) | |||
Custom Toolbar Macro - Path Name | Excel Discussion (Misc queries) | |||
Custom Macro Toolbar? | Excel Discussion (Misc queries) | |||
How do I save a custom toolbar? | Excel Discussion (Misc queries) | |||
custom toolbar w/ macro | Excel Discussion (Misc queries) |