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??
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...
Powered by vBulletin® Version 4.2.5 Copyright © 2024 vBulletin Solutions Inc. All rights reserved.