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.