I would like both if possible. Currently I am using Copy protect one below,
but I ran into a problem in that If the user holds down the shift key when
double-clicking the file to open, the Worksheet_Open function is disabled.

But I definately do not have anything on the macro force when opening.

Private Sub Worksheet_Open()
Application.OnKey "^c", ""
Application.OnKey "^v", ""
Application.OnKey "+{DEL}", ""
Application.OnKey "+{INSERT}", ""
Application.CellDragAndDrop = False
End Sub

Public Sub Workbook_Close()

Application.OnKey "^c"
Application.OnKey "^v"
Application.OnKey "+{DEL}"
Application.OnKey "+{INSERT}"
Application.CellDragAndDrop = True
End Sub

THANKS,
Galindez

"Fable " wrote:

Hi Galindez,

Would you like the code for the Copy & Paste disable or the Event
Handler Macro that does not allow access to the workbook unless the
user enables macro?


Fable

Galindez wrote:
*Fable,

You mentioned that you already have code to do exactly what I have
been
searching for. Would you be willing to share?

Thanks
Galindez

"Fable " wrote:

Hi Julie, it would be a solution for ALT + PRTSC . . . snagit or
other
programs would be difficult to avoid capture (plus my users, are
not
that techy) . THANKS!

Fable


JulieD wrote:
*Hi

do you mean the print screen from the keyboard using alt &
printscreen /
printscreen or if they use a screen capture program such as
snaggit
or
hypersnap or one of those?

Cheers
JulieD

"Fable " wrote in message
...
Greeting,

I'm looking for a way to disable the Print Screen function to
avoid
user from capturing the screen and pasting it to other
application.
I
got the copy functions (menu, sub menu, right clicks etc) all
disable,
but the print screen is the only hurdle left.

I'm looking for a solution that not necessarily use an time
interval to
clear the clip board.

Any thoughts . . .


Fable


---
Message posted from http://www.ExcelForum.com/
*


---
Message posted from http://www.ExcelForum.com/

*


---
Message posted from http://www.ExcelForum.com/