joe-k
05-17-2002, 02:47 PM
I created a floating toolbar with macros attached to it for a specific Excel spreadsheet. Whenever I run another spreadsheet, the floating toolbar appears. But the toolbar has no meaning to any but the original spreadsheet. Is there a way to make the floating toolbar appear only with the intended spreadsheet. It is easy enough to just close the toolbar, but there must be a more elegant solution.
Also if I close the toolbar in a workbook, it no longer appears in the intended spreadsheet and I have to VIEW=>TOOLBARS and select it. I tried to get around this by having a macro that would run when I open the workbook. This macro would bring up the toolbar.
You suggested Private Sub Workbook_Open() , which should run when the workbook is opened. I tried this and it does not work for me. I am using Excel-97. Is this a feature that is not available with Excel-97?
Or is there some other step that I am missing.
Thanks for your help.
Also if I close the toolbar in a workbook, it no longer appears in the intended spreadsheet and I have to VIEW=>TOOLBARS and select it. I tried to get around this by having a macro that would run when I open the workbook. This macro would bring up the toolbar.
You suggested Private Sub Workbook_Open() , which should run when the workbook is opened. I tried this and it does not work for me. I am using Excel-97. Is this a feature that is not available with Excel-97?
Or is there some other step that I am missing.
Thanks for your help.