Results 1 to 5 of 5

HELP with Worksheet_Change(ByVal Target As Range)

Threaded View

  1. #1
    Registered User
    Join Date
    03-21-2010
    Location
    United States
    MS-Off Ver
    Excel 2003
    Posts
    90

    HELP with Worksheet_Change(ByVal Target As Range)

    Hello All,

    I have this code that automates the worksheet based on changes made in certain cells. The issue I am having is when I click on any other empty cell I see the wheel run like it's running the macro again. However, this limits the ability for the user to copy and paste within the spreadsheet. Also, I can't insert a row if I try to. If I right click and try to insert a row then the menu will appear but disappear. It's the same thing when I click on a cell and right click to paste something in the cell the little circle appears like the macro is running and then the menu disappears.

    HTML Code: 
    Last edited by jadown; 02-16-2018 at 10:48 AM.

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 (ByVal target As Range)
    By art_a_game in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 12-12-2016, 11:21 PM
  2. [SOLVED] Private Sub Worksheet_Change(ByVal Target As Range)
    By hmr2662 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-23-2015, 12:35 PM
  3. Replies: 5
    Last Post: 12-16-2014, 05:47 PM
  4. [SOLVED] Worksheet_Change(ByVal Target As Range) - set to only update when 3 target cells changed?
    By trillium in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 11-07-2012, 06:40 PM
  5. Worksheet_CHange (ByVal Target as Range) when target is formula cell
    By coasterman in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-09-2012, 07:00 PM
  6. [SOLVED] use of Worksheet_Change(ByVal Target As Range)
    By Isaac in forum Excel General
    Replies: 2
    Last Post: 07-07-2006, 02:10 PM
  7. [SOLVED] Worksheet_Change(ByVal Target As Excel.Range)
    By Daggi in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 06-29-2005, 10:05 AM

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