Consulting

Results 1 to 3 of 3

Thread: To arrange macros in folders.

  1. #1

    To arrange macros in folders.

    Hi All,

    I am writing macros for various functions as and when the need arises while working in Excel. These are mostly small but useful macros for my work.
    Now there are so many I want to group them easily so that I can identify them quickly. Is there any way that the macros can be stored in folders in the PERSONAL.XLS (just like normal files in folders). I want to arrange them in groups corresponding to the applications I have to deal with in my day to day job. Presently they are distributed in various Excel files.

    - Krishna

  2. #2
    Mac Moderator VBAX Guru mikerickson's Avatar
    Joined
    May 2007
    Location
    Davis CA
    Posts
    2,778
    Macros can be put in different modules with descriptive names.

  3. #3
    Distinguished Lord of VBAX VBAX Grand Master Bob Phillips's Avatar
    Joined
    Apr 2005
    Posts
    25,453
    Location
    .. and then get a copy of Rob Bovey's Code Clenaer app, that lets you export all of your code modules http://www.appspro.com/Utilities/CodeCleaner.htm
    ____________________________________________
    Nihil simul inventum est et perfectum

    Abusus non tollit usum

    Last night I dreamed of a small consolation enjoyed only by the blind: Nobody knows the trouble I've not seen!
    James Thurber

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •