Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
MS Excel: Please help with toolbars/buttons...
I know how to attach a toolbar to a workbook/template, as well as
assign a macro to the button on the toolbar BUT... Why are the BUTTONS on the toolbar not saved...the toolbar is saved sure enough but it's always empty when I reopen the worksheet? Is there a way of ATTACHING THE BUTTONS to the toolbar before saving? Please help... |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
MS Excel: Please help with toolbars/buttons...
Sara, anytime you modify an attached toolbar, you need to delete the old
attached toolbar and attach the new one. Also, it is good practice to delete the attached toolbar when you close the file. This allows the most recently attached toolbar to be the one that is displayed when the file is open. Be sure to do the attaching after you have put all the buttons on the toolbar. And to save the file afterwards! Bob Flanagan Macro Systems http://www.add-ins.com Productivity add-ins and downloadable books on VB macros for Excel "Sara" wrote in message om... I know how to attach a toolbar to a workbook/template, as well as assign a macro to the button on the toolbar BUT... Why are the BUTTONS on the toolbar not saved...the toolbar is saved sure enough but it's always empty when I reopen the worksheet? Is there a way of ATTACHING THE BUTTONS to the toolbar before saving? Please help... |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Toolbars macro buttons snafu | Excel Discussion (Misc queries) | |||
How do I keep from losing toolbars & buttons? | Excel Discussion (Misc queries) | |||
Toolbars Buttons Saving | Excel Discussion (Misc queries) | |||
Restore superscript and subscript buttons in Excel toolbars | Excel Discussion (Misc queries) | |||
Buttons in Toolbars | Excel Programming |