Prevent Copy action Q

S

Sean

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Prevent Save/Publish 0
Automatically copy with save? 8
Why cant I get the path to the sharepoint library???????? 6
save as cell A1 to to a specific drive 3
using two cell references to make up the save as file name 3
How to Save this? 2
Disable save/saveas dialog box upon closing 11
before save event 2

Top