Excel Object Model: CommandBars("Ply")

Disable the right click on a sheet tab

Using the CommandBar named Ply, it is possible to disable right clicks on a sheet tabs

option explicit

sub disable_right_click_on_sheet_tab() ' {

    application.commandBars("Ply").enabled = false

end sub ' }

Thus, after running disable_right_click_on_sheet_tab, the following right click is not possible anymore: