+ Reply to Thread
Results 1 to 4 of 4

How to run Macro from another sheet

  1. #1
    Registered User
    Join Date
    03-06-2020
    Location
    Qatar
    MS-Off Ver
    2019 Mac
    Posts
    7

    How to run Macro from another sheet

    I have a macro in Sheet3 (Connections), Which is updating pivot table in protected sheet.
    I want to run this macro from Sheet4 (Home) and hide Sheet3(connections).

    Please Login or Register  to view this content.
    Last edited by AliGW; 03-21-2020 at 02:06 AM.

  2. #2
    Valued Forum Contributor Eastw00d's Avatar
    Join Date
    02-29-2020
    Location
    Breda, NL
    MS-Off Ver
    2016, 2019
    Posts
    808

    Re: How to run Macro from another sheet

    I just answered this in another thread:
    place the same code in a module instead of the sheetcode. Code placed into a module is available to the whole workbook
    Cheers
    Erwin
    I started learning VBA because I was lazy ...
    Still developing.... being more lazy...

  3. #3
    Registered User
    Join Date
    03-06-2020
    Location
    Qatar
    MS-Off Ver
    2019 Mac
    Posts
    7

    Re: How to run Macro from another sheet

    Erwin, Thanks for your reply,
    I moved codes to module, still its not updating in Sheet3 (ie: I have an update button in sheet4 and Pivot tables in Sheet3, When I click update button in Sheet4 macro should run in Sheet3 and update pivot tables).
    Last edited by beenanu999; 03-21-2020 at 03:31 AM.

  4. #4
    Valued Forum Contributor Eastw00d's Avatar
    Join Date
    02-29-2020
    Location
    Breda, NL
    MS-Off Ver
    2016, 2019
    Posts
    808

    Re: How to run Macro from another sheet

    So, as quoted in the yellow banner above this thread, please upload a non-personalised sample of your worksheet.
    Than I, or anybody can look into your problem.
    Cheers
    Erwin

+ 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] macro creates new sheet and names it, need to create hyperlink to new sheet on main sheet
    By cjburns in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 02-03-2020, 11:26 AM
  2. [SOLVED] Macro updating after selecting another sheet and back to Macro enabled sheet?
    By Imran Magsi in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 02-29-2016, 04:38 AM
  3. [SOLVED] Macro to copy data from a master sheet to separate sheet as per date using a macro
    By tmaster81 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 06-23-2014, 08:05 AM
  4. Macro to gnereate new sheet which includes the macro to generate a new sheet
    By jocanon in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 12-27-2013, 05:15 PM
  5. [SOLVED] Macro running on active sheet instead of sheet defined in macro
    By davegscott in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 02-19-2013, 02:04 PM
  6. [SOLVED] Macro to Copy Data from one Sheet A to Sheet B based on value in cell on sheet A
    By scass in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 09-11-2012, 07:21 PM
  7. Replies: 1
    Last Post: 07-30-2012, 02:35 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