Protect Workbook - prevent move/copy only

Is there a way to password protect a workbook but still allow users to still right click a sheet tab and either rename it or delete it?


I am basically trying to block the move/copy feature to prevent a sheet from being copied to a new workbook and the currently passworded VBA codes from being exposed.

Hi PY,

Run this line of code against your workbook and then save it:

Please Login or Register  to view this content.

The 'Move or Copy' option when right-clicking on a sheet tab will then be disabled (greyed out). As for protecting your VBA code and sheets, if it's built in Excel it can be outwitted in seconds (or minutes if you have to Google how first).

Now that i have added the above to my current workbook. That disable of Move/Copy is true for ALL files i open/create.

I have to add that code to my new workbook and set it to True, then run the code in order to have that ability again. The same is true for all future workbooks.

How can i set the above statement so it only affects the single workbook it is located in rather than all files i open/create after opening the workbook containing that line of code?


Maybe by making it False to workbook open and True to the workbook close? <-- I believe that fixed my problem.