新手花半个多月完成的转线系统，在此感谢帮助过的大侠（修正部分错误）

zhw79

look at this link
http://club.excelhome.net/viewthread.php?tid=502320

KCFONG

Thanks a lot.

lanny.mo

To KCFONG

"EXE" file is to lead open CLS and to skip macro security, and that isn't real "dll" file, I only to change suffix,

pls check 1/F how to do

Sorry for truoble you again, Why not successfully to link when clicks on listbox, you said  too many shapes will caused the file corrupted. But, I thought this problem may not be caused,ths

KCFONG

There were many "Prepare" in Product sheet,
so the macro find the first one.
Now I had use main sheet  cell y3 for indication of rows
Try and see if work.
Moreover, your file corrupted many times.
Try to use Office 2010 and see if better.
Or try to use less shapes, and less font type and color.

lanny.mo

Ths, I try again