+ Reply to Thread
Results 1 to 5 of 5

run a macro in another sheet when a sheet is selected

  1. #1
    Registered User
    Join Date
    06-09-2017
    Location
    germany
    MS-Off Ver
    2010
    Posts
    23

    run a macro in another sheet when a sheet is selected

    Hello all,

    i have tried to use this to run a macro on a sheet but the Thing is that i want it to run on another sheet not the selected one is this possible?

    Please Login or Register  to view this content.
    Last edited by george.m; 08-31-2017 at 04:21 AM.

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

    Re: run a macro in another sheet when a sheet is selected

    What does your badly spelled calculating macro do?

  3. #3
    Valued Forum Contributor spitfireblue's Avatar
    Join Date
    01-29-2015
    Location
    Adelaide, Australia
    MS-Off Ver
    2007,2010,2016
    Posts
    611

    Re: run a macro in another sheet when a sheet is selected

    Yes it is possible.
    Regards,
    Stephen

    If you feel someone has helped you please thank them and click on the star on their post to add reputation.
    Please ensure that you use code tags where relevant, and mark solved threads as solved.
    Most of all please be respectful and understanding of others.

  4. #4
    Registered User
    Join Date
    06-09-2017
    Location
    germany
    MS-Off Ver
    2010
    Posts
    23

    Re: run a macro in another sheet when a sheet is selected

    can you please Show me how it's done
    Last edited by george.m; 08-31-2017 at 07:21 AM.

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

    Re: run a macro in another sheet when a sheet is selected

    Herr George,

    You can run any macro from any sheet. The event you choose to run your macro from doesn't matter, it could be sheet activation (any sheet activation), selection change, worksheet change.....even workbook open. You run your macro in the exact way you show in your original post.

    The bit that matters is the code in the macro that runs. If it's full of commands that start with 'ActiveSheet'.....then you'll need to replace those with the specific sheet you want the command to have an effect on....which is why I ask what your calculation macro does.

+ 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. Replies: 1
    Last Post: 05-12-2016, 03:36 AM
  2. Replies: 2
    Last Post: 05-12-2016, 03:08 AM
  3. [SOLVED] Macro only run if it run from selected sheet
    By robrobet in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-06-2015, 02:19 PM
  4. [SOLVED] Trying to copy selected items from sheet to listbox then selected back to sheet
    By BigWes1960 in forum Excel - New Users/Basics
    Replies: 4
    Last Post: 03-14-2013, 03:27 PM
  5. Replies: 13
    Last Post: 04-04-2012, 01:25 AM
  6. Run Macro in selected sheet only
    By EOD in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 07-16-2010, 11:55 AM
  7. Run a macro in a selected sheet only
    By EOD in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-15-2010, 08:42 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