+ Reply to Thread
Results 1 to 2 of 2

Worksheet_SelectionChange undesirable side effect

  1. #1
    Registered User
    Join Date
    09-05-2009
    Location
    Phoenix, Arizona
    MS-Off Ver
    Office 365
    Posts
    7

    Worksheet_SelectionChange undesirable side effect

    Worksheet_SelectionChange

    My objective is to run a macro when a user clicks a specific cell

    The following code works as expected when the user selects a cell in the monitored range; however, the macro is also run if a user cursors through a cell in the range.

    Is it possible to cause the macro to run only when the range is selected by the user clicking a cell in the range? Or is it possible to keep a user from entering a cell in any way except with a click?


    Please Login or Register  to view this content.
    Last edited by davesexcel; 02-25-2019 at 02:00 AM.

  2. #2
    Forum Moderator davesexcel's Avatar
    Join Date
    02-19-2006
    Location
    Regina
    MS-Off Ver
    MS 365
    Posts
    13,165

    Re: Worksheet_SelectionChange undesirable side effect

    Check out,
    Please Login or Register  to view this content.
    or
    Please Login or Register  to view this content.

+ 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. VBA to change multiple PivotTables at once has an unexpected side effect
    By sadsmileyface in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-01-2016, 07:17 AM
  2. locked cell side effect
    By nicolle80 in forum Excel General
    Replies: 1
    Last Post: 06-15-2015, 06:49 AM
  3. [SOLVED] undesirable change of cells color when expanding/collapsing pivot table
    By ivansamsonov in forum Excel Charting & Pivots
    Replies: 14
    Last Post: 05-28-2013, 09:34 AM
  4. VBA to copy data from multiple sheets side-by-side into one sheet matching date
    By MHCapcog in forum Excel Programming / VBA / Macros
    Replies: 18
    Last Post: 04-02-2013, 06:11 PM
  5. Unneeded VBAProject Side Effect
    By SDruley in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 07-22-2010, 06:37 PM
  6. Undesirable massive increase in file size
    By 1eyedjack in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 04-14-2010, 12:53 PM
  7. Bizarre Side Effect To Hyperlinks
    By eddiesvoicebox in forum Excel General
    Replies: 1
    Last Post: 02-21-2005, 09:09 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