excel menu hidden

Philips / Freevents
January 14, 2009 at 13:53:02
Specs: Windows XP, 1GB
HELP!! I'm creating an accounts program for a friend of mine and, very cleverly, upon finishing the programming decided to hide the menu bar with a piece of vba code. Now, ALL my excel files have the menu bar missing!!! Alt & F etc doesn't work .... does anyone know how I can access VBA to amend/delete the code I've written?? pleeeease!! :)

See More: excel menu hidden

Report •

January 15, 2009 at 05:44:55
alt-f11 gets you to the vba menu

alt-f8 gives you the run macro option

Report •

January 15, 2009 at 06:08:59
Brilliant!! I knew there'd be a way.
Thanks a lot Jon K.

Report •

January 15, 2009 at 08:36:47
Now then!! I get home and open spreadsheet and press alt-f11 - presto - the vba editor - BUT - I can't find the code I wrote!! I followed these instructions :
in the Workbook_Activate procedure of the Workbook Object (ThisWorkbook) add

On Error Resume Next
With Application
.DisplayFullScreen = True
.CommandBars("Worksheet Menu Bar"). Enabled = False
End With
On Error GoTo 0

Now I can't find hide nor hair of this procedure. I click on "This Workbook" in the project explorer and it just gives me blank procedures for Activate & deactivate.

Can anyone help??

Report •

Related Solutions

Ask Question