Prevent copying a READ-Only?

[mitelkm]

I have a very important file, and with the help of the users on this site was able to protect the heck out of it. However, I have found a flaw in my plan. Even with all the passwords and readonly access, users can still copy the sheet and paste onto a new book, thus allowing them re-write access...

Does anyone know how I can prevent this book from being copied? (By all users but admin of course)

Thanks!!

[Paul]

Hello Mitelkm,

The following code taken from http://www.ozgrid.com/VBA/disable-cut-copy.htm should work for you. They utilize your Workbook Activate, Deactivate and SheetSelectionChange events (paste this code into the ThisWorkbook module of your workbook):

Please Login or Register  to view this content.

I added the sections in green/blue to also capture any CTRL+C (copy) and CTRL+X (cut) keyboard commands.

[shg]

Maybe this?

Please Login or Register  to view this content.

[Paul]

You may also want to add this to the Workbook_Activate macro:

Please Login or Register  to view this content.

and this to the Workbook_Deactivate macro:

Please Login or Register  to view this content.

This disables/enables the 'Move or Copy...' command when you right-click on a worksheet tab. The original code I provided, as well as shg, does not prevent this method of copying the sheet(s).

[VBA Noob]

This link may also be of interest

http://www.excelforum.com/showthread.php?t=624239

VBA Noob

[mitelkm]

You Guys are Geniuses I tell ya!! Just Genius!.


Thanks sooo much.....


I love this site. I can always find someone willing to answer my questions and solve my dilemmas!!!

[ClaireCindel]

This work perfectly fine!
Thank you very much, Paul!