disallow copy and paste

[itbman]

is there any way to block users from copying and pasting from my worksheet? Just trying to add a bit of security to my spreadsheet, I think/hope this is the last thing.

 

[Andrew Poulsom]

A couple of ways:

http://www.xcelfiles.com/VBA_Quick13.html

http://www.mrexcel.com/archive2/75500/87639.htm

 

[itbman]

sorry for the double-post... I found this: http://www.mrexcel.com/forum/showthread.php?t=29656&highlight=disallow+copy+paste

works great...but is it possible instead of just getting a msgbox that says " can't copy and paste", it asks for a password?

Some people will have the right/need to copy and paste within the spreadsheet. The simpler it is the better, as they are not as excel savvy as I am, which is not much.

 

[Jonnyu182]

You could set up a basic table with there ID's and have it only run the disable copy/paste code if there name is not on the list.

ive done this a few times.

 

[itbman]

You could set up a basic table with there ID's and have it only run the disable copy/paste code if there name is not on the list.

ive done this a few times.

I think a password prompt would be preferable. I'll keep snooping and see what I can do. Any suggestions would be helpful, right now I'm thinking some type of If statement when they right click, prompting for a password.

 

[Jonnyu182]

password option is a good one,

however if you add it to right click would you set it so they have to enter a password each time?

if so something like

Private Sub Workbook_SheetBeforeRightClick(ByVal Sh As Object, ByVal Target As Range, Cancel As Boolean)
Pass = InputBox("Enter Password", "Promt")
If Pass <> "password" Then Cancel = True
End Sub

will work. however unless you hide the menu bar and disable the ctrl+c, ctrl+v etc keys then this will be easy to workaround

 

[taxstar]

I was testing the following methods (suggested above) to disable copy/paste on a particular worksheet -- now copy and paste is disabled entirely from Excel and, apparently, from each and every excel workbook I've got. HELP!!!!!

http://www.xcelfiles.com/VBA_Quick13.html

http://www.mrexcel.com/archive2/75500/87639.htm



Taxstar