Put it in an add-in or in your Personal Macro Workbook.

--

Vasant

"Kanan" wrote in message
...
Hi,
I have a bunch of VBA code (checks login and sets some values in the
pivotchart) that I need to make it common so that it can be called from any
workbooks. Currently I have this code in auto_open macro.
Can anybody tell me how to do this?
thanks
Kanan