Solved: disable move or copy sheet

[morteza2006]

hi all
How to disable option move or copy?

[morteza2006]

How to disable right click on the tab sheet?

[Esmatullah]

You can easily disable move or copy sheet by protect workbook in Review tab and you don't need to disable right click because by protecting workbook the options (Insert, Delete, Rename, Move or copy sheet, Tab color, Hide, Unhide)
will be disable. Just protect workbook (check the structure and uncheck the windows). Also you can edit your workbook when it is protected.

[morteza2006]

You can easily disable move or copy sheet by protect workbook in Review tab and you don't need to disable right click because by protecting workbook the options (Insert, Delete, Rename, Move or copy sheet, Tab color, Hide, Unhide)
will be disable. Just protect workbook (check the structure and uncheck the windows). Also you can edit your workbook when it is protected.

Hi everyone
Thanks for the response, my good friend
But I wanted to know whether the code can be deactivated completely, right click on the sheet tab??

[GTO]

If you mean you wish to disable this particular context menu, try:

In the ThisWorkbook Module:
[VBA]Option Explicit

Private Sub Workbook_Activate()
Application.CommandBars("Ply").Enabled = False
End Sub

Private Sub Workbook_Deactivate()
Application.CommandBars("Ply").Enabled = True
End Sub[/VBA]

[morteza2006]

If you mean you wish to disable this particular context menu, try:

In the ThisWorkbook Module:
[vba]Option Explicit

Private Sub Workbook_Activate()
Application.CommandBars("Ply").Enabled = False
End Sub

Private Sub Workbook_Deactivate()
Application.CommandBars("Ply").Enabled = True
End Sub[/vba]

Thank you very much
I've solved the problem with your code

[Jan Karel Pieterse]

But you can still access the move/copy sheets item from the ribbon...