+ Reply to Thread
Results 1 to 2 of 2

Sheet selection change from Add-In

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

    Sheet selection change from Add-In

    I have this macro which runs from an Add-In.
    When there is a selection change in column A, it calls up a macro.
    At the moment, it runs on all files and all sheets.

    The files I want to run it on, have the following 2 conditions. Both conditions must be met.
    - The macro only runs on Sheet1 (this is VBA name Sheet1 , not tab name)
    - There is another worksheet called "Aid Sheet" (this is a tab name and not a VBA name).

    ThisWorkbook
    Please Login or Register  to view this content.
    Module1
    Please Login or Register  to view this content.
    ClassChange class module
    Please Login or Register  to view this content.
    Attached Files Attached Files
    Last edited by Un-Do Re-Do; 09-21-2018 at 10:11 PM.

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

    Re: Sheet selection change from Add-In

    I managed to get this to work. In the class module, add the following:

    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. [SOLVED] This Workbook Sheet Change Selection
    By sl729 in forum Excel General
    Replies: 4
    Last Post: 07-04-2016, 08:41 AM
  2. [SOLVED] exec macro on sheet selection change
    By brainzlp in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 02-01-2016, 08:17 AM
  3. Replies: 3
    Last Post: 01-03-2014, 06:39 PM
  4. Change/Shift to another sheet based on user selection in this sheet
    By kittu55 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 10-18-2013, 08:43 PM
  5. [SOLVED] Looking for an easy way to change data on a sheet based on drop-down selection
    By Spritz in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-12-2013, 09:39 AM
  6. Replies: 1
    Last Post: 04-13-2011, 09:30 PM
  7. Replies: 0
    Last Post: 07-17-2008, 01:19 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