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.
Code:
Private Sub Workbook_Activate()
Application.CommandBars("Worksheet Menu Bar").Controls("Data").Enabled = False
End Sub
Disable or Lock "HOME" or "DATA" Menus
With using this code, Menu bar have hide.
but i don't want to hide, I want Disable or Lock "HOME" or "DATA" Menus with all ribbon button/Command using VBA Programming or VBA Code.