+ Reply to Thread
Results 1 to 2 of 2

Enable/disable copy paste (disable part not working)

  1. #1
    Forum Contributor timtim89's Avatar
    Join Date
    01-05-2012
    Location
    Copenhagen, Denmark
    MS-Off Ver
    Excel 2010
    Posts
    141

    Enable/disable copy paste (disable part not working)

    Hey,
    Found a macro for disabling copy/paste on this page:

    http://www.vbaexpress.com/kb/getarticle.php?kb_id=373

    ..but I want to be able to switch it back on again by changing a value in a cell. The macro for copy/pasting is in both ThisWorkbook and in a module.
    The macro that I'm looking for is probably easiest seen from my trials (=errors) shown below.

    Thanks a lot for your help.

    Please Login or Register  to view this content.
    or

    Please Login or Register  to view this content.
    Attached Files Attached Files
    Last edited by timtim89; 03-08-2012 at 07:22 PM.

  2. #2
    Forum Contributor timtim89's Avatar
    Join Date
    01-05-2012
    Location
    Copenhagen, Denmark
    MS-Off Ver
    Excel 2010
    Posts
    141

    Re: Enable/disable copy paste (disable part not working)

    Anyone who can help me just a tiny bit? Totally stuck.. Any input is highly appreciated

+ Reply to 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1