Preventing pasting into Excel from Clipboard

Status
This thread has been Locked and is not open to further replies. Please start a New Thread if you're having a similar issue. View our Welcome Guide to learn how to use this site.

diginav

Thread Starter
Joined
Oct 4, 2008
Messages
6
Hello, I need to protect an Excel document from users pasting from outside that document - believe that means the windows clipboard. I need to allow them to cut/copy/paste data within the document. So, is there any way to disable paste only from the clipboard?
 
Joined
Jul 25, 2004
Messages
5,458
Hi there, welcome to the board!

Well, as there is a difference between the Windows clipboard and the Office clipboard, we do not have programmatic access to control them, afaik. We can open the Windows clipboard, clear it, close it, but just not manipulate the workings of it. You can disable them altogether if you want, but not stipulate if it is from within the application or not. Sorry.
 

diginav

Thread Starter
Joined
Oct 4, 2008
Messages
6
Thanks, appreciate the quick response. I'm trying to set up an Excel spreadsheet for students and want to make sure they are doing their own work, and prevent them from copying and pasting from other people's work or an existing spreadsheet.
 
Joined
Jul 25, 2004
Messages
5,458
You could disable copy/paste altogether then, if you wanted. Excel is a difficult app to lock down. You can if you want, but for somebody who really wants to bypass your security, will. It's really not that difficult. Do not think of Office applications as 'secure', as they're far from it. We may be able to give you certain suggestions if you detail out to us the exact nature of what you're trying to build though. An option. Good luck!
 

valis

Moderator
Joined
Sep 24, 2004
Messages
78,020
agree with zach....you can protect the document, but then you run into un-wanted issues with the functionality of the worksheet; eg, I've got a sheet at work that I, and only I, can modify, but the worksheet is password protected, so I've got to enter a password to modify it.

there may be something in gpedit.msc, but I'm on a vista rig at the time, so can't validate that.
 
Joined
Oct 20, 2004
Messages
7,837
Per this post
http://www.pcreview.co.uk/forums/thread-530285.php
it would appear that, using gpedit.msc, you can disable the clipboard, but it is an all-or-nothing thing. If you want the clipboard for any other use, you are stuck with it in Excel.
As far as keeping pasting from within the file but not from without...I have to agree. Probably could disable ALL paste ability, but I 'm not even sure of that.
 

valis

Moderator
Joined
Sep 24, 2004
Messages
78,020
thanks, slurpee....too lazy to go upstairs to the xp rig, and the only other rig down here is my son's ME, and we all know about ME......:)
 

diginav

Thread Starter
Joined
Oct 4, 2008
Messages
6
Hi,
Thanks. I appreciate the feedback. The goal is to prevent students from cheating on their Excel class projects by cutting and pasting someone else's work. I thought if you could just disable pasting from outside of Excel, it might help towards that end. Disabling paste in general doesn't help in this sense because they need to use that for their work...
 
Status
This thread has been Locked and is not open to further replies. Please start a New Thread if you're having a similar issue. View our Welcome Guide to learn how to use this site.

Users Who Are Viewing This Thread (Users: 0, Guests: 1)

As Seen On
As Seen On...

Welcome to Tech Support Guy!

Are you looking for the solution to your computer problem? Join our site today to ask your question. This site is completely free -- paid for by advertisers and donations.

If you're not already familiar with forums, watch our Welcome Guide to get started.

Join over 807,865 other people just like you!

Latest posts

Staff online

Top