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.
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.