Results 1 to 12 of 12

Thread: Disable Menu Bar ("HOME" AND "DATA") Menu in EXCEL 2007

Threaded View

Previous Post Previous Post   Next Post Next Post
  1. #4
    When I am using below codes in Excel 2003 version, then it properly workbut not work in Excel-2007 version why?

    Private Sub Workbook_Activate()
        Application.CommandBars("Worksheet menu bar").Enabled = False
        Application.CommandBars("Worksheet Menu Bar").Controls("File").Enabled = False
        Application.CommandBars("Worksheet Menu Bar").Controls("Edit").Enabled = False
        Application.CommandBars("Worksheet Menu Bar").Controls("VIEW").Enabled = False
        Application.CommandBars("Worksheet Menu Bar").Controls("INSERT").Enabled = False
        Application.CommandBars("Worksheet Menu Bar").Controls("Format").Enabled = False
    End Sub
    Same like that, what are the VBA Programmig/Code to use in Excel-2007 version by which we Disable/Lock the Menu Bar in Excel-2007 version.
    Last edited by Aussiebear; 04-17-2023 at 11:50 AM. Reason: Added code tags to supplied code

Tags for this 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
  •