Personal.xls.

Personal.xls is located in the XLStart directory, and is used to store
macros and
things that you want to be available to all workbooks, whenever you start
Excel.

By default, it is hidden in Excel, but if you go to the VBE, you use it as
you can
with any other open workbook (you don't have to unhide it).

You can create it by
- goto ToolsMacrosRecord New Macro...
- Choose Personal Macro Workbook form the dropdown
- OK
- click the Stop button on the toolbar that pops-up

You now have a Personal.xls workbook. It is not visible though, it is hidden
by default (WindowsUnhide)


--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"Pranay Shah" wrote in message
...
Hi,

I have a code which I have wrtitten seperately which now I to be
accessible
by all workbooks, I have heard that there is a hidden file where we can
save
this, but I am not able to find it, can anyone please guide me how to go
about it.
--
Regards,
Pranay Shah