Okay thanks
But what about the code to copy the sheet, i'm not good to this

Alvin


"Tom Ogilvy" skrev:

Yes, you can put such code in the workbook_open event

http://www.cpearson.com/excel/events.htm
Chip Pearson's site with a page on events.

--
Regards,
Tom Ogilvy

"Alvin Hansen" wrote in message
...
Hi
I have try to use Inderect.ext diect in a combo box it dosn't work
so i belive i shall have a copy off the sheet where the data are
but this file are close.
Can't i i some way every time i open my file have a makro there take a
copy
off the sheet in the close file and replace it in my open file.
So i can use it with my combobox

alvin