Disable Menu Commands in Excel 2007

[bmckenna]

I was able to remove the ribbon and toolbar from Excel using the following code:

Private Sub HideRibbon()
Application.ExecuteExcel4Macro "show.toolbar(""Ribbon"", FALSE)"
End Sub

What VBA code can I use to run at Workbook opening to remove the commands that can still be accessed via hotkeys (ctrl+s, ctrl+o, etc...)?

 

[bmckenna]

Also...!

Same thing, but to remove formula bar and name box from displaying?

 

[Andrew Poulsom]

You can use the OnKey method as described here:

http://www.mrexcel.com/forum/showthread.php?t=424020

To hide the formula bar:

Application.DisplayFormulaBar = False

 

[bmckenna]

Thanks Andrew, I was unable to find anything when I searched the forum!

 

[bmckenna]

....ecxcept, I have Excel 2007, I hear they are different in the approach?

 

[Andrew Poulsom]

Only the ribbon, which you have already solved. I think disabling shortcut keys and hiding the formula bar will be the same.