how to delete custom menu in excel?

Hello,
I want to delete my custom menu,but although it seems has been removed ,and
then I save this file,but I still find it restore again after I open this
file
How can I delete it?

Any options?
Thanks,
helai

Thanks for your reply

Yes,there are some macros in this file,but even I have deleted macros from
this file,the menu still restored after I reopen the excel file(after try to
delete the custom menu),so it's obviously the custom menu is no related with
menu activation code
actually I want to do some modification for this custom menu,but as you
know,the menu always kept same as before
so now I don't know how to do it

Thanks,
helai

"instruite" <[email protected]> 写入消息新闻:[email protected]...
>
> You didnt specify the details or didnt even posted your code
> If you post the code it will be easy to help you (especially worksheet
> activation code or menu activation code)
> anyways see if the following code helps you
>
>
> Code:
> --------------------
> Public Sub Delete_Menu()
>
> Dim Ctrl As CommandBarPopup
> With Application.CommandBars
> Set Ctrl = .FindControl(Tag:="MenuName")
>
> While Not Ctrl Is Nothing
> Ctrl.Delete
> Set Ctrl = .FindControl(Tag:="MenuName")
> Wend
> End With
>
>
>
> Dim cbrbar As commandbar
> Dim stbarname As String
> stbarname = "MenuName"
>
> For Each cbrbar In Application.CommandBars
> ''' If a match is located, exit the loop.
>
>
> If StrComp(cbrbar.Name, stbarname, vbTextCompare) = 0 Then
> cbrbar.Delete
> Exit For
> End If
> Next cbrbar
> End Sub
> --------------------
>
>
> --
> instruite
>
> I am B.E. Instrumentation and Control and write now working as Hardware
> design engineer in automotive electrconics industry
> ------------------------------------------------------------------------
> instruite's Profile:
> http://www.excelforum.com/member.php...o&userid=26539
> View this thread: http://www.excelforum.com/showthread...hreadid=398819
>

Thank you for giving support always,now I have found the answer.may be it is
not correct,but I think it's almost right,
I guess this file was created by office95 or it's pre,and the custom menu
embeded in file is the special function only vaild for office95 and it's
pre,after that,the microsoft changed his mind,let this function
inactive,leave the mystery to the new people fisrst meet office.

Thanks again
helai
"instruite" <[email protected]> 写入消息新闻:[email protected]...
>
> can you post your code?
> or upload your file?
>
>
> --
> instruite
>
> I am B.E. Instrumentation and Control and write now working as Hardware
> design engineer in automotive electrconics industry
> ------------------------------------------------------------------------
> instruite's Profile:
> http://www.excelforum.com/member.php...o&userid=26539
> View this thread: http://www.excelforum.com/showthread...hreadid=398819
>