Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Hiding Drop Down menu | Excel Programming | |||
Hiding toolbars but keeping the Windows Menu Bar? | Excel Programming | |||
hiding Worksheet menu bar | Excel Programming | |||
hiding Worksheet menu bar | Excel Programming | |||
hiding Worksheet menu bar | Excel Programming |