Remove a command bar

  • Thread starter Thread starter J. I. Howell
  • Start date Start date
J

J. I. Howell

I am using a speadsheet that was initially created in Excel 95. A
custom command bar was added to the sheet (manually, not
programmatically). The spreadsheet has evolved considerable with
extensive VBA macros.

The command bars are now all created on the fly and deleted when done.
Unfortunately, the ORIGINAL command bar always shows up. If the file
is opened using the latest macros, we delete the ORIGINAL command bar.
However, if the file is not opened using our macros, the ORIGINAL
command bar shows up.

How can I get rid of this ORIGINAL command bar once and for all,
hopefully in all versions of the spreadsheet and on all computers that
currently use the spreadsheet and our new software.

Thanks in advance for the great advice and insights provided by this
group.

Respectfully,

John I. Howell
Portfolio Decisions, Inc.
 
Excel '95 saved bars in files with the extension XLB
Do a search - or look in the Excel home folder , and your
default startup folders. Moving or removing XLB files
should stop them from re-appearing.

Patrick Molloy
Microsoft Excel MVP
 
Back
Top