Prevent Copy action Q
 

Is there a way to prevent the "copy" action being allowed, similar to
below for preventing saving, I also have one that prevents a file from
being printed? Can't use the obvious protection facility

Thanks


Private Sub Workbook_BeforeSave(ByVal SaveAsUI As Boolean, Cancel As
Boolean)
Cancel = True
End Sub

Prevent Copy action Q
 

One method here

http://www.vbaexpress.com/kb/getarticle.php?kb_id=373

Mike

"Sean" wrote:


Is there a way to prevent the "copy" action being allowed, similar to
below for preventing saving, I also have one that prevents a file from
being printed? Can't use the obvious protection facility

Thanks


Private Sub Workbook_BeforeSave(ByVal SaveAsUI As Boolean, Cancel As
Boolean)
Cancel = True
End Sub