Can't delete menu button

[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?

[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

"Ltat42a" <[email protected]> wrote in
message news:[email protected]...
>
> 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
>

[swatsp0p]

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

[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

"swatsp0p" <[email protected]> wrote in
message news:[email protected]...
>
> 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
>

[Ltat42a]

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

[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?
>
>

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

--
David

[swatsp0p]

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

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

"swatsp0p" <[email protected]> wrote in message
news:[email protected]...
>
> 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