Hi all,

I'm trying to create a macro/program that when execute will:

1. Ask user to select and open an Excel file.
--archieved this by using GetOpenFile method.
2. Ask user to select multiple sheets in the opened file.
--GOT STUCK here.
3. Copy some infos from the selected sheets to other sheet in othe
file.

I'm stuck in 2. How do I ask user to select multiple sheets?

I tried to open the file and loop through th
Activewindow.Selectedsheet, but only one sheet was selected. There i
no dialog to temporarily stop the macro and ask user to select th
sheets. Any idea how can I solve this

--
hidek
-----------------------------------------------------------------------
hideki's Profile: http://www.excelforum.com/member.php...fo&userid=1890
View this thread: http://www.excelforum.com/showthread.php?threadid=49236