Remove a command bar
 

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.

Remove a command bar
 

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

Remove a command bar
 

Try my remove menus utility on this page:
http://www.bmsltd.co.uk/MVP/Default.htm



--
Jim Rech
Excel MVP