Hi LurfysMa,

How do I know which folder my VBA macros are in? It's not like a VB
project. I just do Alt+F11.

In Excel, VBA code is a part of a workbook.
Excel has a special workbook called "Personal macro workbook", with a
filename of Personal.xls (or in Excel 2007 personal.xlsb). This
workbook is hidden from the user interface and is stored in a folder
called:

C:\Documents and settings\YourUserName\Application
Data\Microsoft\Excel\XLSTART\

Regards,

Jan Karel Pieterse
Excel MVP
http://www.jkp-ads.com
Member of:
Professional Office Developer Association
www.proofficedev.com