Customised Menu

paddymack

Board Regular
Joined
Oct 24, 2002
Messages
143
Hi guys,
I know how to add extra menu's to the excel main menu (File, edit, view, MYMENU, Insert, Format...etc) What I want to do is Remove the basic excel menu choices at the same time so as to just leave my menu choices. Anyone know how to do this?
 

Some videos you may like

Excel Facts

Can a formula spear through sheets?
Use =SUM(January:December!E7) to sum E7 on all of the sheets from January through December

jimboy

Well-known Member
Joined
Apr 11, 2002
Messages
2,314
Right mouse over the toolbar/menu bar and select customize and then click and drag the ones you don't want into the customize box
 

paddymack

Board Regular
Joined
Oct 24, 2002
Messages
143
Sorry, I obviously didn't explain myself properly. I'm not looking to get rid of the Worksheet Menu Bar, just hide the File, Edit View...etc menu options but leave menu options I have added visible.
 

k209310

Active Member
Joined
Aug 12, 2002
Messages
382
If i understand you righ you want to delete some of the items on the standard menu bar.

if you right click on the menu bar and click on customize it is then possible to clickonm the item you wish to delete. simply drag the item off the bar and it will delete.

Let me know if this is totally wrong
 

Haluk

Rules Violation
Joined
Oct 26, 2002
Messages
1,075

ADVERTISEMENT

Hi;

With this, you can hide the "File" menu of the Worksheet Menu Bar. Similarly, you can hide the ones that you don't want to see. Or, you can make a for-next loop to hide all of the standard menus.

Application.CommandBars("Worksheet Menu Bar").Controls("File").Visible = False
 

paddymack

Board Regular
Joined
Oct 24, 2002
Messages
143
Kind of..... but this way causes problems. I can remove the menu items no problem using VBA - I Just can't reattach them afterwards. I tried recording a macro of selecting customise...reset but It did not record anything? So I have no way of returning the menu to its original state afterwards...
 

Haluk

Rules Violation
Joined
Oct 26, 2002
Messages
1,075
Hi again;

This may work;

Application.CommandBars("Worksheet Menu Bar").Reset
 

paddymack

Board Regular
Joined
Oct 24, 2002
Messages
143
Sorry Raider! must have posted my reply at the same time as yours. Your first suggestion worked perfectly - exactly what I wanted! thanks.
 

Watch MrExcel Video

Forum statistics

Threads
1,122,564
Messages
5,596,870
Members
414,106
Latest member
Tigretto

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
Top