+ Reply to Thread
Results 1 to 5 of 5

Workbook Change event to exclude a specific sheet

  1. #1
    Registered User
    Join Date
    07-17-2019
    Location
    London, England
    MS-Off Ver
    2010
    Posts
    27

    Workbook Change event to exclude a specific sheet

    Hello all!

    I am using a workbook change event that moves data from one table to another on another sheet depending on a cells value.

    Link to original query

    This is working very well, however it is a workbook event which means for every sheet if a cell in row "O" is edited, row N is populated with data and every time row "B" is edited the macro attempts to move the row of any sheet. How can I make the workbook change event not happen for a specific sheet. I have a dashboard a the front of the workbook that I am currently avoiding putting anything in columns "B" and "O"

    Please Login or Register  to view this content.
    Many thanks!

  2. #2
    Forum Expert Mumps1's Avatar
    Join Date
    10-10-2012
    Location
    Toronto, Canada
    MS-Off Ver
    Excel 2010, 2013
    Posts
    7,821

    Re: Workbook Change event to exclude a specific sheet

    Try inserting this line of code at the very beginning of the macro. Change the sheet name (in red) to suit your needs.
    Please Login or Register  to view this content.
    You can say "THANK YOU" for help received by clicking the Star symbol at the bottom left of the helper's post.
    Practice makes perfect. I'm very far from perfect so I'm still practising.

  3. #3
    Forum Guru bakerman2's Avatar
    Join Date
    10-03-2012
    Location
    Antwerp, Belgium
    MS-Off Ver
    MO Prof Plus 2016
    Posts
    6,908

    Re: Workbook Change event to exclude a specific sheet

    Put this on top of your code. Change DashBoard to appropriate sheet name.

    Please Login or Register  to view this content.
    Avoid using Select, Selection and Activate in your code. Use With ... End With instead.
    You can show your appreciation for those that have helped you by clicking the * at the bottom left of any of their posts.

  4. #4
    Registered User
    Join Date
    07-17-2019
    Location
    London, England
    MS-Off Ver
    2010
    Posts
    27

    Re: Workbook Change event to exclude a specific sheet

    Cheers both!

  5. #5
    Forum Expert Mumps1's Avatar
    Join Date
    10-10-2012
    Location
    Toronto, Canada
    MS-Off Ver
    Excel 2010, 2013
    Posts
    7,821

    Re: Workbook Change event to exclude a specific sheet

    Glad to help.

+ 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. [SOLVED] textbox change event sheet reference will not work if another workbook open
    By nigelog in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 02-17-2017, 08:48 AM
  4. [SOLVED] change event AND calculate event on the same sheet
    By lauriejerome in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 09-14-2013, 03:54 PM
  5. Exclude printing a specific worksheet in a workbook
    By Steven811 in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 08-29-2012, 04:35 AM
  6. specific cell change event
    By cesna123 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 08-09-2010, 11:50 AM
  7. Workbook sheet change event prompts save
    By pprseller in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 10-29-2009, 02:12 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