Can't delete menu button

L

Ltat42a

I created a menu button (same row as File, Edit, View, etc..). It is
assigned to a macro for a spreadhseet I was using. I no longer need the
spreadsheet or the menu button, how do I get rid of the button? Tried &
tried - no luck

Any suggestions?
 
P

Paul B

Ltat42a, right click on the menu bar then right click on the button, delete
--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003
 
S

swatsp0p

Paul said:
Ltat42a, right click on the menu bar then right click on the button,
delete
Click to expand...

Paul forgot to mention that after right clicking on the menu bar to
choose 'Customize'. THEN right click on your desired button and choose
'Delete'.

Good Luck
 
P

Paul B

swatsp0p, thanks, I must have been thinking faster than I can type!
--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003
 
L

Ltat42a

swatsp0p said:
Paul forgot to mention that after right clicking on the menu bar to
choose 'Customize'. THEN right click on your desired button and choose
'Delete'.

Good Luck
Click to expand...

Ah.....got it. Worked great....Thanx!

JF
 
D

David

Ltat42a wrote
I created a menu button (same row as File, Edit, View, etc..). It is
assigned to a macro for a spreadhseet I was using. I no longer need the
spreadsheet or the menu button, how do I get rid of the button? Tried &
tried - no luck

Any suggestions?
Click to expand...

In Excel 2000 at least, you can hold down the Alt key and drag the button
off the toolbar.
 
S

swatsp0p

David said:
In Excel 2000 at least, you can hold down the Alt key and drag the
button
off the toolbar.
Click to expand...

Great tip, David. I learn more each day by accident than by design!

Thanks for sharing.

Bruce
 
D

David McRitchie

Hi David T.,
That's cool, and something I am less likely to forget after trying it.

It seems like something you learned accidentally. Another tip would
be to how to restore your toolbars if you accidentally make the
wrong changes to your toolbars. Do a search on *.xlb and
find and click on the last modified, which should be the date and time you
last saved Excel. You must not have hidden extensions.
http://www.mvps.org/dmcritchie/excel/toolbars.htm#emergency
 
Top