PDA

View Full Version : To arrange macros in folders.



krishnak
01-21-2008, 03:20 PM
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

mikerickson
01-21-2008, 03:58 PM
Macros can be put in different modules with descriptive names.

Bob Phillips
01-21-2008, 04:59 PM
.. 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