+ Reply to Thread
Results 1 to 2 of 2

Subsequent Change Events re-triggering other macros

  1. #1
    Registered User
    Join Date
    10-21-2015
    Location
    London
    MS-Off Ver
    2010
    Posts
    1

    Subsequent Change Events re-triggering other macros

    I'm trying to have my Excel spreadsheet delete out certain parts of the form based on values entered into it.

    It works for the first instance, but then returns a 1004 error referring me to the macro that has already run, saying that the object no longer exists (because the macro has already run once and deleted it)

    Below is a copy of my change event and macros (they are identical except for their names and which checkbox they delete)

    Any help on this would be very much appreciated!

    Please Login or Register  to view this content.

  2. #2
    Forum Guru Kaper's Avatar
    Join Date
    12-14-2013
    Location
    Warsaw, Poland
    MS-Off Ver
    most often: Office 365 in Windows environment
    Posts
    8,613

    Re: Subsequent Change Events re-triggering other macros

    Try first such simple trick:
    Please Login or Register  to view this content.
    Best Regards,

    Kaper

+ 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] Exclude macros from triggering msgbox
    By Jamesera27 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 05-04-2015, 11:43 PM
  2. [SOLVED] BeforeSave .Save / .SaveAs events not triggering when triggered by macro
    By TC1980 in forum Excel Programming / VBA / Macros
    Replies: 13
    Last Post: 11-25-2013, 11:59 AM
  3. Triggering Macros from Validation List
    By Pratster in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 11-06-2010, 10:16 PM
  4. Triggering Worksheet Events
    By gnaiggg in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 02-25-2007, 05:31 AM
  5. Triggering Macros
    By Sloth in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-27-2006, 11:25 AM
  6. triggering macros
    By gvm in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 09-17-2005, 12:05 PM
  7. Triggering an excel menu using macros
    By Sassy in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 07-08-2005, 08:05 PM

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