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?


--
Ltat42a
------------------------------------------------------------------------
Ltat42a's Profile: http://www.excelforum.com/member.php...o&userid=24735
View this thread: http://www.excelforum.com/showthread...hreadid=482870

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

"Ltat42a" wrote in
message ...

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?


--
Ltat42a
------------------------------------------------------------------------
Ltat42a's Profile:
http://www.excelforum.com/member.php...o&userid=24735
View this thread: http://www.excelforum.com/showthread...hreadid=482870

Paul B Wrote:
Ltat42a, right click on the menu bar then right click on the button,
delete
--


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


--
swatsp0p


------------------------------------------------------------------------
swatsp0p's Profile: http://www.excelforum.com/member.php...o&userid=15101
View this thread: http://www.excelforum.com/showthread...hreadid=482870

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

"swatsp0p" wrote in
message ...

Paul B Wrote:
Ltat42a, right click on the menu bar then right click on the button,
delete
--


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


--
swatsp0p


------------------------------------------------------------------------
swatsp0p's Profile:
http://www.excelforum.com/member.php...o&userid=15101
View this thread: http://www.excelforum.com/showthread...hreadid=482870

swatsp0p Wrote:
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

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

JF


--
Ltat42a
------------------------------------------------------------------------
Ltat42a's Profile: http://www.excelforum.com/member.php...o&userid=24735
View this thread: http://www.excelforum.com/showthread...hreadid=482870

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?



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

--
David

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

--
David

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

Thanks for sharing.

Bruce


--
swatsp0p


------------------------------------------------------------------------
swatsp0p's Profile: http://www.excelforum.com/member.php...o&userid=15101
View this thread: http://www.excelforum.com/showthread...hreadid=482870

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....htm#emergency
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm

"swatsp0p" wrote in message
...

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

--
David

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

Thanks for sharing.

Bruce