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.
|