Custom Toolbar

[kchan]

I created a custom toolbar that had buttons with different assigned macros. It was attached to a workbook through View/Toolbars/Customize/Attach/Copy. Because I want that toolbar to show only when I open that workbook, I wrote a macro like this.

Sub Auto_Close()
Toolbars("Go To Schedule").Delete
End Sub

But when I opened the workbook again, the toolbar was still there but all the buttons were gone.

What went wrong? Is it the right way to do it? Thanks.

 

[mweaver]

KChan;

This happens to me when I try to modify a previously created custom toolbat. Try this:

After you have made changes to a custom toolbar you must re-attach it to the worksheet. To re-attach it you must first delete it, then attach it, Save, Close. When you open you should see the changes you made.

good luck

mweaver