View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
sgeels sgeels is offline
external usenet poster
 
Posts: 2
Default 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.