+ Reply to Thread
Results 1 to 1 of 1

Worksheet Change - exclude Paste

  1. #1
    Forum Contributor
    Join Date
    11-10-2009
    Location
    Perth, Australia
    MS-Off Ver
    Excel 2007
    Posts
    549

    Worksheet Change - exclude Paste

    I have a macro which is called up if there is a change in Column A.
    There are two functions I want to exclude as being changes.
    (1) Paste. (2). Insert Rows.
    With the first item, I have something which works in a round-about way. But it's buggy. For instance, if a value is entered in a cell anywhere on the sheet, and then "Undo" is called, it throws up an error. Nothing really to do with using "Paste".
    Is there something which would be more logical to use?

    The part which is buggy is in comment blocks, in the Class Module.

    THIS WORKBOOK
    Please Login or Register  to view this content.
    MODULE
    Please Login or Register  to view this content.
    CLASS MODULE
    Please Login or Register  to view this content.
    Attached Files Attached Files

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Worksheet change event to exclude the Insert Rows and Delete Rows
    By Un-Do Re-Do in forum Excel Programming / VBA / Macros
    Replies: 13
    Last Post: 09-15-2018, 04:51 AM
  2. [SOLVED] Worksheet change event to exclude the Paste function
    By Un-Do Re-Do in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 09-13-2018, 04:44 AM
  3. Put comma by copy paste in Worksheet Change
    By emina002 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 02-05-2018, 08:54 AM
  4. [SOLVED] Trigger Worksheet Change by copy and paste
    By maddog9486 in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 05-20-2014, 12:05 PM
  5. [SOLVED] Cannot paste to another worksheet in private sub change event
    By LouiseH24 in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 05-10-2012, 06:58 AM
  6. Copy and Paste using worksheet change
    By arader1216 in forum Excel Programming / VBA / Macros
    Replies: 34
    Last Post: 02-05-2012, 12:12 AM
  7. Macro to create worksheet, change it's position, and paste date into it.
    By dcgrove in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 08-19-2009, 02:47 PM

Tags for this Thread

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