Stefan,

Personal.xls is a file that Excel knows about, and is normally used to store
your personal, application wide code. If you go to ToolsMacroRecord New
Macro ..., and you will see a dialog. If you click the drop-down on the
right, one of the options is Personal.xls. Just select that and click OK<
then hit the Stop Recording button immediately. That will create a
Personal.xls file for you. This is saved in the XLStart directory, and
automatically opens when Excel starts, but in a non-visible state. This is a
good file for stuffing code like this.

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"Stefan" <123@abc wrote in message
...
"Bob Phillips" wrote:

Stefan,

I would have put it in Personal.xls, not have another file opened.

--
HTH


Can you give me some more information, i cant follow.
Is personal.xls the name of that file and in which directory must i save
it??

thnx
Stefan