+ Reply to Thread
Results 1 to 2 of 2

Is it possible to have multiple personal.xlsb workbooks?

  1. #1
    Registered User
    Join Date
    03-04-2019
    Location
    Wisconsin
    MS-Off Ver
    2016
    Posts
    1

    Is it possible to have multiple personal.xlsb workbooks?

    Before I try this, I want to see if anyone else has tried this. A coworker and I have both have personal.xlsb's with different macros and want to share each other's global macros. Is it possible to save each other's personal workbooks with different file names to the same location and access both sets of macros? Seems easier than copying the modules from one to the other. It seems like it could be done, however, it could be problematic if the same hot keys are assigned to various macros. Let me know if you have tried this, or if you see any other issues from doing this, or any other thoughts. Thanks.

  2. #2
    Forum Expert shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2003, 2010
    Posts
    40,678

    Re: Is it possible to have multiple personal.xlsb workbooks?

    You could create add-ins instead and share those. Shortcuts common to both would prioritize the last add-in installed.
    Entia non sunt multiplicanda sine necessitate

+ 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] Ignore personal.xlsb when counting open workbooks
    By nigelog in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 07-26-2017, 11:46 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. Replies: 0
    Last Post: 01-15-2015, 05:53 AM
  4. VBA beginner question - Does the functionality of personal.xlsb go with workbooks?
    By brucemc777 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-22-2014, 12:32 PM
  5. Automatically close hidden workbooks (Personal.xlsb)
    By JonSnow in forum Excel General
    Replies: 5
    Last Post: 01-29-2014, 09:24 AM
  6. Replies: 1
    Last Post: 08-07-2013, 09:12 PM
  7. 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

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