I lost my Macro menu

[NewbyNewbyNew]

I am not sure how I turned it off, but i am stumped as to how to turn it back on.

[OllieB]

Assuming you have Excel 2007, click on the round icon in the top left corner, select Excel Options and under Popular tick show Developer tab in ribbon

[NewbyNewbyNew]

I can see the macro window. the the macro tool bar and navagational window do not appear.

[OllieB]

- Right-click the menu and use customise
- Press Ctl-R (or select View - Project Explorer), and F4 to display properties window

[NewbyNewbyNew]

Great - At least now I can see the project and properties windows. While in the macro window I do not see a menu to right click on. When I rigth click on the Excel menu, it appears that those optoin are for Excel windows and not macro windows.

Thank for your help
John

[OllieB]

I am not behind a PC at the moment, but was there not an option on the ribbon customise screen to revert back to the original settings?

[NewbyNewbyNew]

No, not that I can see. I have to developer tab in the main Excel Window. i do not have a menu on the top of my developer window. this is very frustrating. i delete a line of code by accident and i can even undo.

[OllieB]

I am not behind a pc at the moment so I cannot help you right now

[NewbyNewbyNew]

I found it. I had to close Excel completely and re-openned. I swore I had tried that. Thanks for your help.

signed

Mr. EggOnFace