+ Reply to Thread
Results 1 to 3 of 3

Cannot Run Multiple Macros on Same Worksheet Without Modifying Worksheet

  1. #1
    Registered User
    Join Date
    05-31-2014
    MS-Off Ver
    2010
    Posts
    2

    Cannot Run Multiple Macros on Same Worksheet Without Modifying Worksheet

    I have a workbook with four macros, all linked to Form Control buttons.

    1. Creates a copy of the current worksheet.
    2. Creates a copy of the current worksheet and selects and deletes data (basically creates a blank worksheet).
    3. Selects and deletes data in a range.
    4. Overwrites data in a different range.

    If I run macros 1 or 2, I cannot run any additional macros on the same sheet until I have modified the sheet in some way (e.g. entering and immediately deleting text in a cell). I can run 3 and 4 without issue. Any idea why?
    Last edited by Sorliene; 02-21-2017 at 01:18 PM.

  2. #2
    Valued Forum Contributor
    Join Date
    03-24-2014
    Location
    England
    MS-Off Ver
    Excel 2003 - 2016
    Posts
    575

    Re: Cannot Run Multiple Macros on Same Worksheet Without Modifying Worksheet

    Not without seeing your code....

  3. #3
    Registered User
    Join Date
    05-31-2014
    MS-Off Ver
    2010
    Posts
    2

    Re: Cannot Run Multiple Macros on Same Worksheet Without Modifying Worksheet

    Thanks for replying; turns out the buttons had just glitched. (I assigned keystroke shortcuts to the macros and had no issues.) Created new buttons, linked them to the same macros, no issues.

+ 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 on multiple columns calling different Macros
    By mattcass87 in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 01-09-2017, 04:39 PM
  2. Prgram Multiple macros in a worksheet
    By brendonlayne in forum Excel Programming / VBA / Macros
    Replies: 14
    Last Post: 08-23-2016, 08:03 AM
  3. [SOLVED] VBA Macros to add multiple checkboxes and forlumas on worksheet
    By hecgroups in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 02-12-2015, 11:00 AM
  4. Multiple Macros on on worksheet
    By themie in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 09-18-2012, 09:06 PM
  5. WorkSheet List Box Multiple Selection by Macros
    By karan in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 07-05-2012, 01:35 AM
  6. [SOLVED] Using Multiple Tests and Sounds With Worksheet Macros
    By Carl in forum Excel General
    Replies: 3
    Last Post: 07-01-2006, 02:40 PM
  7. [SOLVED] Worksheet with multiple Hyperlinks and Macros
    By Anolan in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 02-01-2006, 11:10 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