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

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

    I am using Microsoft Excel 2007.
    I want to disable "HOME" and "DATA" Menu bar I Microsoft Excel 2007 using VBA.
    I'm using below code but not work.

    Private Sub Workbook_Activate()
    Application.CommandBars("Worksheet Menu Bar").Controls("Data").Enabled = False
    End Sub
    Last edited by Aussiebear; 04-17-2023 at 11:46 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