+ Reply to Thread
Results 1 to 3 of 3

Run Macro from Personal.xlsb on SheetChange in Any Opened and Active xlsx

  1. #1
    Registered User
    Join Date
    05-07-2013
    Location
    CZ, EU
    MS-Off Ver
    2010/2016
    Posts
    31

    Run Macro from Personal.xlsb on SheetChange in Any Opened and Active xlsx

    Hello,

    I'd like to run macros from Personal.xlsb to avoid inserting them into individual workbooks and saving the workbooks as xlsm.

    The only problem I have is with macros placed in ThisWorkbook object of xlsm files, triggered on SheetChange.

    To make it simple, this is a sample macro, which just opens a messagebox:

    Please Login or Register  to view this content.
    How can I make it work from Personal.xlsb, so that the macro will be triggered by any opened/active workbook (xlsx) on its "SheetChange"?

    Thanks for helping me.

  2. #2
    Forum Expert rorya's Avatar
    Join Date
    08-13-2008
    Location
    East Sussex, UK
    MS-Off Ver
    365 Ent Monthly Channel / Insiders Beta
    Posts
    8,903

    Re: Run Macro from Personal.xlsb on SheetChange in Any Opened and Active xlsx

    You need application events, not workbook events: http://www.cpearson.com/Excel/AppEvent.aspx
    Rory

  3. #3
    Registered User
    Join Date
    05-07-2013
    Location
    CZ, EU
    MS-Off Ver
    2010/2016
    Posts
    31

    Re: Run Macro from Personal.xlsb on SheetChange in Any Opened and Active xlsx

    I'll try, thanks.

    Edit:
    Yes, it works perfectly. Thanks for your advice. Good one
    Last edited by hhost; 03-21-2019 at 09:48 AM.

+ 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] Call a Macro in the Active Workbook from a Personal.xlsb procedure [RESOLVED]
    By Seke in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-15-2015, 06:17 AM
  2. [SOLVED] Personal.XLSB macro pasting into Personal.XLSB
    By davepoth in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 07-11-2015, 07:40 PM
  3. Running a Personal.XLSB Macro From Within Another Personal.XLSB Macro
    By js0873 in forum Excel Programming / VBA / Macros
    Replies: 18
    Last Post: 06-23-2015, 09:58 AM
  4. [SOLVED] Run PERSONAL.XLSB macro when any Excel file is opened
    By Aaron092 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 09-23-2014, 04:35 AM
  5. control of active workbooks when 2 open and code in personal.xlsb
    By alan_m20 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 11-12-2012, 02:23 PM
  6. Replies: 0
    Last Post: 10-30-2012, 12:29 PM
  7. Macros in Personal.xlsb not available when Excel is opened from another app
    By Muskett32 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-15-2012, 02:57 AM

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