Excel 2003 - Worksheet menu bar

March 29, 2007 at 01:36:32
Specs: XP Pro - SP2, Athlon 2.2/768Mb DDR RAM

I've managed to hide the Worksheet Menu Bar in excel, but i cant get it back. I used this macro to hide it when i was using a worksheet in fullscreen.

Application.DisplayFullScreen = True
Application.CommandBars("Full Screen").Enabled = False
Application.CommandBars.ActiveMenuBar.Enabled = False

I didnt save the workbook, closed excel last night and this morning i have everything apart from "File, Edit, View....etc" (e.g i have the standard toolbar, drawing toolbar etc...)

First thing i did was whacked the office disc in and did a reinstall... It didnt help

Anyone help my get it back?

Cheers Pete

See More: Excel 2003 - Worksheet menu bar

Report •

March 29, 2007 at 02:50:44
Nevermind - Fixed it

Application.commandbars("Worksheet Menu Bar").Enabled=True in the immediate window

Report •
Related Solutions

Ask Question