Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old November 28th 04, 08:15 PM
Dennis
 
Posts: n/a
Default How to remove an Excel Main Menu item inserted by .xla file

Excel 2003 & 97

Thought I knew how to do this. But ...

An .xla file placed a new item on the Main Menu (along with File, Edit,
........ Help, Misc) Let us call it "Misc".

I removed the Misc.xla file from Addins folder and forced Excel to ask me to
remove it from the Addins list.

But the Misc is still on the Main Menu bar.

How do I get rid of it?

TIA Dennis

  #2   Report Post  
Old November 28th 04, 08:19 PM
Frank Kabel
 
Posts: n/a
Default

Hi
one way: Close Excel and start it again.

--
Regards
Frank Kabel
Frankfurt, Germany

"Dennis" schrieb im Newsbeitrag
...
Excel 2003 & 97

Thought I knew how to do this. But ...

An .xla file placed a new item on the Main Menu (along with File,

Edit,
....... Help, Misc) Let us call it "Misc".

I removed the Misc.xla file from Addins folder and forced Excel to

ask me to
remove it from the Addins list.

But the Misc is still on the Main Menu bar.

How do I get rid of it?

TIA Dennis


  #3   Report Post  
Old November 28th 04, 08:21 PM
Peo Sjoblom
 
Posts: n/a
Default

Try this, do viewtoolbarscustomize, grab the offending menu and drag it
from any menu toolbar (I usually drag it to the sheet)

--
Regards,

Peo Sjoblom

(No private emails please, for everyone's
benefit keep the discussion in the newsgroup/forum)



"Dennis" wrote in message
...
Excel 2003 & 97

Thought I knew how to do this. But ...

An .xla file placed a new item on the Main Menu (along with File, Edit,
....... Help, Misc) Let us call it "Misc".

I removed the Misc.xla file from Addins folder and forced Excel to ask me
to
remove it from the Addins list.

But the Misc is still on the Main Menu bar.

How do I get rid of it?

TIA Dennis



  #4   Report Post  
Old November 28th 04, 08:23 PM
Dennis
 
Posts: n/a
Default

Got it!

Sub DeleteMenuBarItem()
Application.CommandBars("Worksheet Menu Bar").Controls("Misc").Delete

End Sub


Thanks

"Dennis" wrote:

Excel 2003 & 97

Thought I knew how to do this. But ...

An .xla file placed a new item on the Main Menu (along with File, Edit,
....... Help, Misc) Let us call it "Misc".

I removed the Misc.xla file from Addins folder and forced Excel to ask me to
remove it from the Addins list.

But the Misc is still on the Main Menu bar.

How do I get rid of it?

TIA Dennis

  #5   Report Post  
Old November 28th 04, 08:27 PM
Dennis
 
Posts: n/a
Default

I tried that Frank and it did not work.

Thanks for taking your time!!

Dennis

****************************************

"Frank Kabel" wrote:

Hi
one way: Close Excel and start it again.

--
Regards
Frank Kabel
Frankfurt, Germany

"Dennis" schrieb im Newsbeitrag
...
Excel 2003 & 97

Thought I knew how to do this. But ...

An .xla file placed a new item on the Main Menu (along with File,

Edit,
....... Help, Misc) Let us call it "Misc".

I removed the Misc.xla file from Addins folder and forced Excel to

ask me to
remove it from the Addins list.

But the Misc is still on the Main Menu bar.

How do I get rid of it?

TIA Dennis





  #6   Report Post  
Old November 28th 04, 08:39 PM
Dennis
 
Posts: n/a
Default

Peo,

Your solution is what I learned a year ago, but unfortunately forgot about
it because I had not
used it recently!

Thanks Dennis

********************************

"Peo Sjoblom" wrote:

Try this, do viewtoolbarscustomize, grab the offending menu and drag it
from any menu toolbar (I usually drag it to the sheet)

--
Regards,

Peo Sjoblom

(No private emails please, for everyone's
benefit keep the discussion in the newsgroup/forum)



"Dennis" wrote in message
...
Excel 2003 & 97

Thought I knew how to do this. But ...

An .xla file placed a new item on the Main Menu (along with File, Edit,
....... Help, Misc) Let us call it "Misc".

I removed the Misc.xla file from Addins folder and forced Excel to ask me
to
remove it from the Addins list.

But the Misc is still on the Main Menu bar.

How do I get rid of it?

TIA Dennis






Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel How do I create a comma delineated xls file to a comma delineated. Mark Excel Discussion (Misc queries) 0 November 26th 04 10:28 PM
Open a file in excel from a link in eplorer Dave Peterson Excel Discussion (Misc queries) 0 November 26th 04 01:25 AM


All times are GMT +1. The time now is 11:08 PM.

Powered by vBulletin® Copyright ©2000 - 2018, Jelsoft Enterprises Ltd.
Copyright 2004-2018 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017