i need to setup a personal workbook to save macros and stuff in. i dont remember how to do this- actually i don't remember doing this at all. i thought it is installed when you install excel. Does anyone know how to add this personal workbook?
Simply add your macros to an empty workbook. From the menu choose Window, Hide and close the file.
Move the file to your Excel start folder. In W2k it is:
C:\Documents and Settings\UserName\Application Data\Microsoft\Excel\XLSTART
Now every time Excel starts, it will load this workbook as hidden and your macros will be available. I name mine Personal.xls so that I can easily find it.