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