Forum Discussion
Lorenzo Kim
Mar 20, 2018Bronze Contributor
prevent copying or duplicating a worksheet
when I press <ctrl> key and at the same time use mouse pointer to drag sheet to the right - it creates an exact copy of the worksheet - HOW CAN I PREVENT THIS? or how to deactivate this function.. ma...
Wyn Hopkins
Mar 20, 2018MVP
Hi Lorenzo Kim, can I ask why you want to do this? If you go to the Review Tab and select protect workbook that will prevent any changes to tabs
Lorenzo Kim
Mar 21, 2018Bronze Contributor
Mr Wyn Hopkins
the protect workbook will prevent the sheets from being copied all right - but it does to all worksheets; what I need is to deactivate copy sheet to only one specific worksheet - not to all -
Thank you