Posted by George on December 15, 2001 9:26 AM
I have created a custom toolbar that i only want to use for one workbook. The toolbar contains a button with a macro that Closes the toolbar, saves the workbook, then closes it. This works OK.
The problem is that when I open the workbook, i want the toolbar to appear automatically.
I created an AutoExec VBA Module to do this, but it doesnt work. The toolbar will display if i run the AutoExec Macro once the sheet is open.
The code for my AutoExec VBA Module is:
Application.CommandBars("tbr").Visible = True
Am i doing something wrong?