| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excell copy action pauses for 15 second for the smallest action | Excel Discussion (Misc queries) | |||
| Copy Sheet action very slow | Excel Discussion (Misc queries) | |||
| protecting ceels to copy -paste action | New Users to Excel | |||
| protecting ceels to copy -paste action | Excel Discussion (Misc queries) | |||
| VBA Code Interferring with User's Copy Action | Excel Programming | |||
Hybrid Mode
