hiding the Menu bar
 

hi

i have a database running in excel, and i have a main control
worksheets, but i want to hide certain elements. i can run this code,
but the last line fails. any ideas would be good.

Sub Auto_open()
ActiveWindow.DisplayWorkbookTabs = False
Application.DisplayScrollBars = False
Application.DisplayFormulaBar = False
Application.CommandBars("standard").Visible = False
Application.CommandBars("formatting").Visible = False
Application.CommandBars("Worksheet Menu Bar").Visible = False

yours

Eliot
IT Trainer


--
kcammandc
------------------------------------------------------------------------
kcammandc's Profile: http://www.excelforum.com/member.php...o&userid=16333
View this thread: http://www.excelforum.com/showthread...hreadid=277208

hiding the Menu bar
 

This command made it disappear for me in XL XP.

Commandbars("Worksheet Menu Bar").Enabled = False

On Wed, 10 Nov 2004 15:52:32 -0600, kcammandc
wrote:


hi

i have a database running in excel, and i have a main control
worksheets, but i want to hide certain elements. i can run this code,
but the last line fails. any ideas would be good.

Sub Auto_open()
ActiveWindow.DisplayWorkbookTabs = False
Application.DisplayScrollBars = False
Application.DisplayFormulaBar = False
Application.CommandBars("standard").Visible = False
Application.CommandBars("formatting").Visible = False
Application.CommandBars("Worksheet Menu Bar").Visible = False

yours

Eliot
IT Trainer

hiding the Menu bar
 

Try

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

--

HTH

RP
(remove nothere from the email address if mailing direct)


"kcammandc" wrote in message
...

hi

i have a database running in excel, and i have a main control
worksheets, but i want to hide certain elements. i can run this code,
but the last line fails. any ideas would be good.

Sub Auto_open()
ActiveWindow.DisplayWorkbookTabs = False
Application.DisplayScrollBars = False
Application.DisplayFormulaBar = False
Application.CommandBars("standard").Visible = False
Application.CommandBars("formatting").Visible = False
Application.CommandBars("Worksheet Menu Bar").Visible = False

yours

Eliot
IT Trainer


--
kcammandc
------------------------------------------------------------------------
kcammandc's Profile:
http://www.excelforum.com/member.php...o&userid=16333
View this thread: http://www.excelforum.com/showthread...hreadid=277208