Results 1 to 2 of 2

Thread: Turning off the Main Menu bar

  1. Feb 5th, 2004, 08:15 AM #1
    daved2424
    daved2424 is offline

    Thread Starter
    Member
    Join Date
    Dec 2003
    Posts
    38

    Post Turning off the Main Menu bar

    I am trying to turn off the main menu command bar in Excel. Why does this code not work?

    Application.CommandBars("Worksheet Menu Bar").Visible = False

    Many Thanks
    Reply With Quote Reply With Quote
  2. Feb 7th, 2004, 08:19 PM #2
    TheFIDDLER
    TheFIDDLER is offline
    Lively Member TheFIDDLER's Avatar
    Join Date
    May 2002
    Location
    here and there and far away
    Posts
    126
    I think this is what you are looking for:

    Application.CommandBars("Worksheet Menu Bar").Enabled = False
    -----
    #VBA, VB 6 Professional Edition, Office XP Developper. Excel 97, Excel 2000, Excel XP

    I miss my VIC 20.
    Never should have upgraded to my commodore 64. ...
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules


Click Here to Expand Forum to Full Width