View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
Gord Dibben Gord Dibben is offline
external usenet poster
 
Posts: 22,906
Default How to hide Excel's Top Menu Bar

Thanks Hotbird

Great to get feedback.

These newsgroup are definitely a great resource.

Gord

On Thu, 27 Nov 2003 21:49:04 -0000, "Hotbird" wrote:

Many thanks Gord and Vasant. Your solutions worked like a dream. What a
resource this NewsGroup is!!!

<Gord Dibben wrote in message
.. .

Sub hideme()
Application.CommandBars("Worksheet Menu Bar").Enabled = False
End Sub

Sub unHideme()
Application.CommandBars("Worksheet Menu Bar").Enabled = True
End Sub

Gord Dibben XL2002

CommandBars(1).Enabled = False