| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
open worksheet without menus
I created a form in Excel. I want to be able to open the form (worksheet)
without any menu bars being visible. I tried creating a Workbook_Open macro with the following command but it doesn't work: Application.CommandBars("Worksheet Menu Bar").Visible = False The error message is: "Method 'visible" of object 'CommandBar' failed. |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
open worksheet without menus
Try
Application.CommandBars("Worksheet Menu Bar").Enabled = False Gord Dibben Excel MVP On Sun, 23 Oct 2005 15:09:03 -0700, sgeels wrote: I created a form in Excel. I want to be able to open the form (worksheet) without any menu bars being visible. I tried creating a Workbook_Open macro with the following command but it doesn't work: Application.CommandBars("Worksheet Menu Bar").Visible = False The error message is: "Method 'visible" of object 'CommandBar' failed. |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
open worksheet without menus
OUTSTANDING! Thanks for the help!
"Gord Dibben" wrote: Try Application.CommandBars("Worksheet Menu Bar").Enabled = False Gord Dibben Excel MVP On Sun, 23 Oct 2005 15:09:03 -0700, sgeels wrote: I created a form in Excel. I want to be able to open the form (worksheet) without any menu bars being visible. I tried creating a Workbook_Open macro with the following command but it doesn't work: Application.CommandBars("Worksheet Menu Bar").Visible = False The error message is: "Method 'visible" of object 'CommandBar' failed. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| most of menus are dimmed and the worksheet is invisible | Excel Discussion (Misc queries) | |||
| Theres no toolbars, no drop-down menus when I open Excel | Setting up and Configuration of Excel | |||
| create menus in excel worksheet | Excel Worksheet Functions | |||
| Make all menus fully open | Excel Programming | |||
| Make Windows XP menus open fully expanded | Excel Programming | |||
Linear Mode
