I am in Big Trouble... Please help !!!

Premanshu

Board Regular
Joined
Oct 2, 2007
Messages
91
Hi,

I have actually got the Window menu in the Main Menu Bar of excel deleted using below command.

Application.CommandBars("Worksheet Menu Bar").Controls("Window").Delete

I just want to get that back anyhow.....

Please help me ........


Regards
Premanshu.
 

Excel Facts

What is the fastest way to copy a formula?
If A2:A50000 contain data. Enter a formula in B2. Select B2. Double-click the Fill Handle and Excel will shoot the formula down to B50000.
You could reset the whole menu using:
Code:
Application.CommandBars("Worksheet Menu Bar").Reset

or you can use View-Toolbars-Customize and copy the Window menu back there.
 
Upvote 0
that was awesome !!!!!
Thank you sooooooooo Much rorya....
you really saved my life......
thank you so much once again ...... :)>

Regards
Premanshu.
 
Upvote 0
Hi rorya...

would need your expert knowledge in something i was doing....

I am actually trying to disable or delete one Menu from the main menu bar which is not a part of MicroSoft Excel itself.... it's there in all the systems of our company which is used to classify a document before closing it.... as what kind of document it is (Personal, Confidential, Official, restricted...etc). The only problem with this is.... if we do not want to classify the document and click on the close button a msgbox appears asking if we want to classify the document or not. Though we have a option there also of selecting not..... but i want to compleatly disable it on systems where people do not compleatly need to classify there documents.
I deleted it from the menu bar but it still pops up when i try to close the file.
would you advice something on how to disable this...

Regards
Premanshu.
 
Upvote 0
That sounds like an add-in - you would have to uninstall the add-in.
 
Upvote 0
No,
I actually checked that also..... but it's not an addin....
and this is not something done in VBA coding atleast..... else we could see that in the vba environment.
I don't know how they have done it....
 
Upvote 0
I bet it is an add-in, but it's probably a COM add-in, which won't appear in the add-ins list.
 
Upvote 0
You can add the 'COM add-ins' item to the menu via the Customize dialog, but if the add-in has been installed for all users, it will not appear in this list and you would need to modify the registry to disable it, or uninstall the program that installed it in the first place.
 
Upvote 0
to put in my two cents - where I use to work and we had Novel e-mail there was an add-in that controlled save, save as, open, close. So that might be where you have those msgbox's from. It could be seen in the vba editor project window
 
Upvote 0

Forum statistics

Threads
1,213,535
Messages
6,114,194
Members
448,554
Latest member
Gleisner2

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top