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.

or more simple

record a macro and choose the location to be personal Macro Workbook

and this will automatically create your personal.xls file for you

Simple is better.