Articles

Excel 2003 - Worksheet menu bar

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

Hello,

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 •


#1
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