Menus

harvster

New Member
Joined
Aug 15, 2002
Messages
15
I've deleted all my standard menus (File,edit,windows etc etc )by dragging them off screen while I was trying to customise my menu with a custom menu. I don't seem to be able to get them back. Any ideas ?
 

Excel Facts

What is the last column in Excel?
Excel columns run from A to Z, AA to AZ, AAA to XFD. The last column is XFD.

harvster

New Member
Joined
Aug 15, 2002
Messages
15
I've just ran the last piece of the code, as I thought this may work ( my VB skills are limited !!)This bit .....

Sub RestoreMenus()

Application.ScreenUpdating = False

Application.CommandBars("Worksheet Menu Bar").Enabled = True
Application.CommandBars("Worksheet Menu Bar").Visible = True
Application.CommandBars("Standard").Visible = True
Application.CommandBars("Formatting").Visible = True

End Sub


It didn't seem to fgive me any of my menu's back. Am I running the wrong piece ?
 

royUK

Well-known Member
Joined
Jul 24, 2002
Messages
1,606
The Excel addin from http://www.asap-utilities.com has a vision control which enbles the toolbars to be hidden and restored by clicking on it. Not really sure if it will work in this case and i am not about to delete my toolbars to find out. You can download it for free and try to use the restore toolbars button
Good luck
 

harvster

New Member
Joined
Aug 15, 2002
Messages
15

ADVERTISEMENT

I'm afraid that hasn't worked. Any more ideas ????
 

Richie(UK)

MrExcel MVP
Joined
May 17, 2002
Messages
3,329
Hi harvster,

I think I may have misunderstood you. Just to clarify, have you 'deleted' your menus or have you just moved them and now can't see them?
 

harvster

New Member
Joined
Aug 15, 2002
Messages
15

ADVERTISEMENT

Deleted them ( I think ). Went to toolbars customize and then dragged the file command from the menu and it disappeared, Did this for all commands so I was just left with my custom menu. Now I can't get file or any of the others back !
 

Richie(UK)

MrExcel MVP
Joined
May 17, 2002
Messages
3,329
I must confess I haven't had this problem before. However, I notice on the Customise box that there is a 'Reset' option - have you tried it?
 

harvster

New Member
Joined
Aug 15, 2002
Messages
15
I have tried that. It restores the toolbars rather than the menus. I think I'll try having excel re installed. That seems my only option !
 

Dragracer

Board Regular
Joined
Jun 9, 2002
Messages
151
Interesting problem. Don't know why your reinstall didn't work. Try this.<pre>
Sub test1()
Application.CommandBars(1).Reset
Application.CommandBars(1).FindControl(Id:=30002, recursive:=True).Reset

End Sub</pre>

P.S. It is better to post back to your original thread and move it back to the top then starting a new one.
That way others can follow the help ideas easier.
This message was edited by Dragracer on 2002-08-29 12:04
 

Forum statistics

Threads
1,148,213
Messages
5,745,417
Members
423,951
Latest member
peggrif

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