+ Reply to Thread
Results 1 to 3 of 3

Stop users from Cut/Copy & Paste

  1. 11-21-2006, 03:19 PM #1
    rmcveigh
    rmcveigh is offline
    Registered User
    Join Date
    08-10-2006
    Posts
    9

    Question Stop users from Cut/Copy & Paste

    Hello all,

    Is there any way to prevent users of a sheet from pasting data in from another source? I need a way to stop them from cut/copy and paste (i.e. all manual entries).

    Any suggestions?
    Reply With QuoteRegister To Reply
  2. 11-21-2006, 03:28 PM #2
    dominicb
    dominicb is offline
    Forum Expert dominicb's Avatar
    Join Date
    01-25-2005
    Location
    Lancashire, England
    MS-Off Ver
    MS Office 2000, 2003, 2007 & 2016 365
    Posts
    4,867

    Smile

    Good evening rmcveigh

    This is a bit tricky because you have to disable the main menu bar, the toolbars and any keyboard shortcuts. This routine by Ivan F Moala does the trick, and tidies up before the user closes.

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

    If you would rather leave the toolbars etc untouched I have a routine I wrote a while ago (somewhere - just have to find it) that checks the clipboard every 3 seconds and removes anything in it. Just a slightly different way of solving the problem...

    HTH

    DominicB
    Please familiarise yourself with the rules before posting. You can find them here.
    Reply With QuoteRegister To Reply
  3. 11-21-2006, 04:09 PM #3
    rmcveigh
    rmcveigh is offline
    Registered User
    Join Date
    08-10-2006
    Posts
    9
    Perfect. Thanks....
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1