PDA

View Full Version : Solved: disable move or copy sheet



morteza2006
12-10-2012, 06:41 AM
hi all
How to disable option move or copy?
http://upcity.ir/images/05263758413430353876.jpg

morteza2006
12-11-2012, 03:29 AM
How to disable right click on the tab sheet?

Esmatullah
12-11-2012, 06:25 AM
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
12-11-2012, 10:32 PM
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
12-11-2012, 11:47 PM
If you mean you wish to disable this particular context menu, try:

In the ThisWorkbook Module:
Option Explicit

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

Private Sub Workbook_Deactivate()
Application.CommandBars("Ply").Enabled = True
End Sub

morteza2006
12-12-2012, 12:42 AM
If you mean you wish to disable this particular context menu, try:

In the ThisWorkbook Module:
Option Explicit

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

Private Sub Workbook_Deactivate()
Application.CommandBars("Ply").Enabled = True
End Sub
Thank you very much
I've solved the problem with your code

Jan Karel Pieterse
12-12-2012, 01:27 AM
But you can still access the move/copy sheets item from the ribbon...