+ Reply to Thread
Results 1 to 5 of 5

Managing MANY different macros within a single personal file?

  1. #1
    Forum Contributor
    Join Date
    05-10-2011
    Location
    London, England
    MS-Off Ver
    Excel 2019
    Posts
    145

    Managing MANY different macros within a single personal file?

    Hi,
    In my personal file (that located in the XLSTART folder) I have about 100 different macros for different purposes, many of them are in a massive use.
    Its very comfortable for me to have them all in the personal file because i can always use each one of them on any active sheet from many different workbooks.

    The only problem is that many times it take quite some time to find the necessary macro for the specific task that I am busy with, its such a long list that it take a lot of time to scroll down the list and look carefully at the titles of the macros till I find the necessary one...

    I am just wondering: is there a way (or tool or add-in or whatever) that can help me to find the necessary macro by making a simple "macro search" by simply typing a keyword and find the macro quickly?

    Many thanks for a good advice!

    Sami
    Last edited by sami770; 12-02-2014 at 12:23 PM.

  2. #2
    Forum Expert
    Join Date
    10-09-2012
    Location
    Dallas, Texas
    MS-Off Ver
    MO 2010 & 2013
    Posts
    3,049

    Re: Managing MANY different macros within a single personal file?

    TO get around this issue, I created a MACRO folder, and just open the file, run it, then close it and proceed. This allows me to use Windows Explorer instead of VBE.
    Please ensure you mark your thread as Solved once it is. Click here to see how.
    If a post helps, please don't forget to add to our reputation by clicking the star icon in the bottom left-hand corner of a post.

  3. #3
    Forum Contributor
    Join Date
    03-14-2013
    Location
    FL
    MS-Off Ver
    Excel 2013
    Posts
    123

    Re: Managing MANY different macros within a single personal file?

    you can also asign shortcut to your macros. if you have a txt document with all the macro name and shortcuts that might help expedite things. but as far as an add-in ive never heard of one.

  4. #4
    Forum Expert
    Join Date
    10-09-2012
    Location
    Dallas, Texas
    MS-Off Ver
    MO 2010 & 2013
    Posts
    3,049

    Re: Managing MANY different macros within a single personal file?

    Actually, yeah I used to have them all as shortcuts. I liked it, until the PC crashed and needed to be reimaged.... At this point is when I decided to keep them in a folder instead of the personal macro section.

  5. #5
    Forum Contributor
    Join Date
    03-14-2013
    Location
    FL
    MS-Off Ver
    Excel 2013
    Posts
    123

    Re: Managing MANY different macros within a single personal file?

    i agree i have all my macros in a separate txt document for safe keeping, but for expediting things the shortcuts i think is his best bet.

+ 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. macros in personal.xls file
    By Steve E in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 03:05 PM
  2. [SOLVED] macros in personal.xls file
    By Steve E in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 12:05 PM
  3. macros in personal.xls file
    By Steve E in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 10:05 AM
  4. [SOLVED] macros in personal.xls file
    By Steve E in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-05-2005, 11:05 PM
  5. [SOLVED] shortcut to open file in personal.xls blocking file's macros
    By in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-13-2005, 09:05 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