Worksheet Menu Bar

[boxcaru]

Hello,

Does anyone know if it is possible to completely remove the Worksheet Menu bar from an Excel spreadsheet using VBA code?

Thanks

[XLGibbs]

Yes
[VBA]Sub disableWorksheetMenu()
Application.CommandBars(1).Enabled = False
End Sub
[/VBA]

[Zack Barresse]

Hello,

No, you cannot remove it. But you can make it's Enabled property False; don't try to make it Visible, that will fail.

..

[vba]Option Explicit

Sub ToggleWMB()
' On Error Resume Next
With Application.CommandBars("Worksheet Menu Bar")
If .Visible = True Then
.Enabled = False
Else
.Enabled = True
End If
End With
End Sub[/vba]

Edit: Doh! Too slow for Gibbs again! LOL!

[Bob Phillips]

Hello,

No, you cannot remove it. But you can make it's Enabled property False; don't try to make it Visible, that will fail.

As I understand the word remove, that is removing it. It was there, it is now somewhere else, it is removed. It is not deleted, but that was not what was asked.

[Zack Barresse]

I considered the word "removed" as "deleted", hence my post, but I see your point.

[boxcaru]

thanks very much...