邢唷> DC  !"#$%&'()*+,-./0123456789:;<=>?@AB}1FGHIJKLMNP^RSTUVWXYZ[\]O_`abcdefghijklmnopqrstuvwxyz{|Root Entry F`愮X E@AWorkbook_VBA_PROJECT_CUR" T 愮X VBA嘟 愋G  T8衫\plenovo Ba= ThisWorkbook=hJ{9"8X@"1媅SO1媅SO1媅SO1媅SO1媅SO1媅SO1媅SO1 媅SO1媅SO1媅SO1 媅SO1 媅SO1媅SO1 媅SO1 媅SO1 媅SO1 媅SO1* MS Sans Serif1Arial1* MS Sans Serif1Arial1媅SO1媅SO1 媅SO1h8媅SO1,8媅SO18媅SO18媅SO1媅SO1媅SO1媅SO14媅SO1 媅SO1媅SO1 媅SO14媅SO1<媅SO1?媅SO1>媅SO14Microsoft YaHei UI""#,##0;""\-#,##0""#,##0;[Red]""\-#,##0""#,##0.00;""\-#,##0.00#""#,##0.00;[Red]""\-#,##0.007*2_ ""* #,##0_ ;_ ""* \-#,##0_ ;_ ""* "-"_ ;_ @_ .))_ * #,##0_ ;_ * \-#,##0_ ;_ * "-"_ ;_ @_ ?,:_ ""* #,##0.00_ ;_ ""* \-#,##0.00_ ;_ ""* "-"??_ ;_ @_ 6+1_ * #,##0.00_ ;_ * \-#,##0.00_ ;_ * "-"??_ ;_ @_ \$#,##0_);\(\$#,##0\)\$#,##0_);[Red]\(\$#,##0\) \$#,##0.00_);\(\$#,##0.00\)% \$#,##0.00_);[Red]\(\$#,##0.00\) yyyy/m/d;@""#,##0;\-""#,##0""#,##0;[Red]\-""#,##0""#,##0.00;\-""#,##0.00#""#,##0.00;[Red]\-""#,##0.0050_-""* #,##0_-;\-""* #,##0_-;_-""* "-"_-;_-@_-,'_-* #,##0_-;\-* #,##0_-;_-* "-"_-;_-@_-=8_-""* #,##0.00_-;\-""* #,##0.00_-;_-""* "-"??_-;_-@_-4/_-* #,##0.00_-;\-* #,##0.00_-;_-* "-"??_-;_-@_- 0.000000_  0.00000_  0.0000_  0.000_  0.00_ #,##0.00_ ;\-#,##0.00;;#,##0.00_ ;\-#,##0.00 0.00_ ;\-0.00"Yes";"Yes";"No""True";"True";"False""On";"On";"Off"],[$ -2]\ #,##0.00_);[Red]\([$ -2]\ #,##0.00\) "/f";"/f";"&T" "w";"w";"GP" "_";"_";"sQ" 000000 0.000000 0.00000 [$-804]aaa;@0_ 0_);[Red]\(0\) 0.0000% 0.0_  0.0% #,##0.00_  #,##0.0_  0.E+00 0.0000000_  0;_< 0;_>9_ ""* #,##0.00_ ;_ ""* \-#,##0.00_ ;_ ""* \-??_ ;_ @_ 61_ ""* #,##0_ ;_ ""* \-#,##0_ ;_ ""* \-_ ;_ @_ 0.00_ ;[Red]\-0.00\ 0.00_);[Red]\(0.00\) 0;_ 0;_ 0_ ;[Red]\-0\  0;_@ 0;_ 0;_0.0_);[Red]\(0.0\) 0;_ 0;_ 0;_ 0;_ 0;_ 0;_h0.00;[Red]0.00[DBNum2][$-804]General 0_);\(0\)0.0;_ 0;[Red]0 #,##0_                                      P P       a> , *    !攆f " # $` + ) % & '             @ @  x@ @  0@ @  @ @ 0@ @   1  1|@ @  14@ @ 1 1 14@ @     x@@   x@   x @  8@@ 8@ 8 @  x@@   x @  8  1|@@   1|@   1| @  8@@  8@  8@  8  8@  8 0@    0 0 0@ 0 0 x@@  x@  x @   x@@   x@   x @  ||p.C4銄-} #0_ ;_ "}-} #0_ ;_ "}-} #0_ ;_ "}-} #0_ ;_ "}A} #0_ ;_ "ef_ @_ -}A} #0_ ;_ "ef _ @_ -}A} #0_ ;_ "蘈_ @_ -}A} #0_ ;_ "蘈_ @_ -}-} #0_ ;_ "}A} #0_ ;_ "蘈_ @_ -}A} #0_ ;_ "蘈_ @_ -}A} #0_ ;_ "蘈 _ @_ -}A} #0_ ;_ "23_ @_ -}A} #0_ ;_ "23_ @_ -}-} #0_ ;_ "}-} #0_ ;_ "}A}  #0_ ;_ "23_ @_ -}-}! #0_ ;_ "}-}# #0_ ;_ "}A}$ #0_ ;_ "_ @_ -}A}% #0_ ;_ "?_ @_ -}A}& #0_ ;_ "23_ @_ -}-}' #0_ ;_ "}A}( #0_ ;_ "俏_ @_ -}A}* a#0_ ;_ "騎_ @_ -}U}+ #0_ ;_ "_ @_ -##0.}}. 鷠#0_ ;_ "蝌_ @_ -##0.  }}/ #0_ ;_ "ゥ_ @_ -???##0.??? ??? ???}-}0 #0_ ;_ "}-}1 #0_ ;_ "}A}2 鷠#0_ ;_ "_ @_ -}A}9 #0_ ;_ "_ @_ -}A}: #0_ ;_ "_ @_ -}A}; #0_ ;_ "_ @_ -}A}< #0_ ;_ "_ @_ -}A}= #0_ ;_ "_ @_ -}A}> #0_ ;_ " _ @_ -}A}5 渆#0_ ;_ "霚_ @_ -}}6 ???#0_ ;_ "蝌_ @_ -???##0.??? ??? ???}}7 ??v#0_ ;_ "虣_ @_ -##0.  }x}?#0_ ;_ "膊虣_ @膊## 膊 膊 20% - @wr 1; 20% - @wr 1 % 20% - @wr 2;" 20% - @wr 2 % 20% - @wr 3;& 20% - @wr 3 % 20% - @wr 4;* 20% - @wr 4 % 20% - @wr 5G. 20% - @wr 5 ef陬 % 20% - @wr 6G2 20% - @wr 6  ef % 40% - @wr 1G 40% - @wr 1 蘈柑 % 40% - @wr 2G# 40% - @wr 2 蘈娓 % 40% - @wr 3;' 40% - @wr 3 % 40% - @wr 4G+ 40% - @wr 4 蘈湯 % 40% - @wr 5G/ 40% - @wr 5 蘈忿 % 40% - @wr 6G3 40% - @wr 6  蘈 % 60% - @wr 1G 60% - @wr 1 23暢 % 60% - @wr 2G$ 60% - @wr 2 23跂 % 60% - @wr 3;( 60% - @wr 3 % 60% - @wr 4;, 60% - @wr 4 % 60% - @wr 5G0 60% - @wr 5 23捦 %! 60% - @wr 6;4 60% - @wr 6 %* ColLevel_1* ColLevel_2* ColLevel_3* ColLevel_4 * ColLevel_5 * ColLevel_6* ColLevel_7* RowLevel_1* RowLevel_2* RowLevel_3* RowLevel_4 * RowLevel_5 * RowLevel_6 * RowLevel_7"~vR詋 #h槝+h槝 I}% $h槝 1=h槝 1 I}%O伣 %h槝 2=h槝 2 I}%?Э &h槝 3=h槝 3 I}%23暢 'h槝 4/h槝 4 I}%(頬5頬 俏 %8^膲)厤*}Y5}Y 騎 a% +Gl;`GGl;` %O伣O伣,'^- '^[0] .梴o梴 蝌 鷠% /纇錱USCQ@wr 6;1@wr 6  鳀F % ?鑜蕬^ 鑜蕬 膊膊膊 膊XTableStyleMedium9PivotStyleLight16`薆f[u膥竅Ye錧膥苙Ye錧蕍頧膥VV2gfNf8@Z餜3 A@@  T D詋[嵞~+R 7T鹼筫_ 7耂[峌SMO 7啒  7Ye 脋 7錧\O篘XT 7ID鱏 77uP[覻 T 7耂[峺橆v1 7耂[峺橆v2 7耂[峺橆v3 7耂[峺橆v4 7耂[峺橆v5 7{|媁 7鶴u錯g 7珟貧 7SO蛻 7劅 7sYP[覻 T 7 5uP[ Te圗Q魦f: 720覻 T孴耂[峺橆v/f臺kX剉y橆v vQ僛酧o`颯錘 愰b'`kX橯0 730 T筽鸔耂[峺橆v N蒪FhsS颯0{|媁 NkX橯貫:N<詋[>0 740鲖 N亯鹠燫Rb頞9e Th#@xw@汚ccjB杶-z4n欰甠)k:~yw T8衫 0RH2RX  d褚MbP?_*+%;&R&6 Nwm"}o忲N www.softmay.com&~窟鑭?'~窟鑭?(M&撋d2?)M&撋d2?MEPSON LQ-630K ESC/P28C飥 4dA4DINU"$XoiqSMTJEPSON LQ-630K ESC/P2InputBinMANUALRESDLLUniresDLLOrientationPORTRAITResolutionOption2PaperSizeA4PrintQualityOption1HalftoneHT_PATSIZE_AUTOISPE" dXX 兞`? 兞`?&腵c勌U} ` J}  } @ }  } }  J} } } } } @ }  } 0wwwwww                      O+OOOOOOOOOOO E E EG F& X'XXXXXXXXX E@E?E  VWPQQQQQQQQR ~ E@E~ E  VWPQQQQQQQQR VWPQQQQQQQQR VWmnnnnnnnno VWYZZZZZZZZ[ VW j-kkkkkkkkl H A A A A A A A H  A  A  A IB@@@@@@IBBB  IB@@@@@@IBBB  IB@@@@@@IBBB  IB@@@@@@IBBB  IB@@@@@@IBBB IB@@@@@@IBBB IB@@@@@@IBBB IB@@@@@@IBBB IB@@@@@@IBBB IB@@@@@@IBBB IB@@@@@@IBBB IB@@@@@@IBBB H A A A A A A A H  A  A  AIB@@@@@@IBBB IB@@@@@@IBBB IB@@@@@@IBBB IB@@@@@@IBBB IB@@@@@@IBBB IB@@@@@@IBBB IB@@@@@@IBBB IB@@@@@@IBBB IB@@@@@@IBBB IBCCCCCCLDDD DlXzp....B""""""""""""""""""""" !"#$%&'()*+,-./  IB@@@@@@IBBB !\!] !S,!TTTTTTTTU "^_ "b"ccccccccd #^_ #b#eeeeeeeef # ! #" ## #$ #% $`a $g$hhhhhhhhi $9 % . %. %:%@@ &K & / &/&5@5@ 'M'MMMMMMMMMM ' 0 '0'7@7@ (M(MMMMMMMMMM ( 1 (1(D@D@)NNNNNNNNNNN ) 2 )2)N@N@*MMMMMMMMMMM * 3 *3*繯@繯@+MMMMMMMMMMM + 4 +4+@R@@R@,MMMMMMMMMMM , 5 ,5,@Y@@Y@-NNNNNNNNNNN - 6~ -@^@ . 7~ .^@ / 8~ /_@$,"B8~F@@^^RRRR<稷饖(  餜  C   ]F!  ,>@   ## $$      !!   !$"" '' (( -- )) ** ++ ,, 77  %$%  /  %$  /  %$  Sheet1b(b(  gghPh  (-  :S遅1_1 T8衫 /闬蔲l  d褚MbP?_*+%&?'?(?)?"?? &c勌U} ` J}  } @ }  } }  J} } } } } @ }  } /wwwwww                      O;OOOOOOOOOOO E E EG F( X)XXXXXXXXX E@E?E  VWPQQQQQQQQR ~ E@E~ E  VWPQQQQQQQQR VWPQQQQQQQQR VWmnnnnnnnno VWPQQQQQQQQR VW j=kkkkkkkkl H A A A A A A A H  A  A  A IB@@@@@@IBBB  IB@@@@@@IBBB  IB@@@@@@IBBB  IB@@@@@@IBBB  IB@@@@@@IBBB IB@@@@@@IBBB IB@@@@@@IBBB IB@@@@@@IBBB IB@@@@@@IBBB IB@@@@@@IBBB IB@@@@@@IBBB IB@@@@@@IBBB H A A A A A A A H  A  A  AIB@@@@@@IBBB IB@@@@@@IBBB IB@@@@@@IBBB IB@@@@@@IBBB IB@@@@@@IBBB IB@@@@@@IBBB IB@@@@@@IBBB IB@@@@@@IBBB IB@@@@@@IBBB IBCCCCCCLDDD DlXzp....B""""""""""""""""""""" !"#$%&'()*+,-. IB@@@@@@IBBB !\!] !S<!TTTTTTTTU "^_ "b"ccccccccd #^_ #b#eeeeeeeef # ! #" ## #$ #% $`a $g$hhhhhhhhi $9 % . %. %:%@@ &K & / &/&5@5@ 'M'MMMMMMMMMM ' 0 '2'7@N@ (M(MMMMMMMMMM ( 2 (3(N@繯@)NNNNNNNNNNN ) 3 )4)繯@@R@*MMMMMMMMMMM * 4 *5*@R@@Y@+MMMMMMMMMMM + 5~ +@Y@,MMMMMMMMMMM , >~ ,`@-NNNNNNNNNNN ""B8~F@@^^RR<< >@NJ?''    !$!!    ++ ,, --  (( )) ** "" ## $$ 7/  %$ /  %$  7  %$%   Sheet2b(b(44gghTh  (-  :S遅1_1_1 T8衫 /鴒貀騷  d褚MbP?_*+%&?'?(?)?"?? &c勌U} ` J}  } @ }  } }  J} } } } } @ }  } /wwwwww                      O@OOOOOOOOOOO E E EG F& X*XXXXXXXXX E@E?E  VWPQQQQQQQQR ~ E@E~ E  VWPQQQQQQQQR VWPQQQQQQQQR VWmnnnnnnnno VWPQQQQQQQQR VW jAkkkkkkkkl H A A A A A A A H  A  A  A IB@@@@@@IBBB  IB@@@@@@IBBB  IB@@@@@@IBBB  IB@@@@@@IBBB  IB@@@@@@IBBB IB@@@@@@IBBB IB@@@@@@IBBB IB@@@@@@IBBB IB@@@@@@IBBB IB@@@@@@IBBB IB@@@@@@IBBB IB@@@@@@IBBB H A A A A A A A H  A  A  AIB@@@@@@IBBB IB@@@@@@IBBB IB@@@@@@IBBB IB@@@@@@IBBB IB@@@@@@IBBB IB@@@@@@IBBB IB@@@@@@IBBB IB@@@@@@IBBB IB@@@@@@IBBB IBCCCCCCLDDD DlXzp....B""""""""""""""""""""" !"#$%&'()*+,-. IB@@@@@@IBBB !\!] !S?!TTTTTTTTU "^_ "b"ccccccccd #^_ #b#eeeeeeeef # ! #" ## #$ #% $`a $g$hhhhhhhhi $9 % B %C %:%S@@S@ &K 'M'MMMMMMMMMM (M(MMMMMMMMMM )NNNNNNNNNNN *MMMMMMMMMMM +MMMMMMMMMMM ,MMMMMMMMMMM -NNNNNNNNNNN ""B8~F@,, >@NJ?''    !$!!    ++ ,, --  (( )) ** "" ## $$ 7/  %$ /  %$  7  %$%   Sheet3b(b(22gghTh  (-  :S遅1_1_1 ThisWorkbook+ __SRP_25r__SRP_3 KSheet1Q*[  !"#$%&'()*+,-./012346789:;<=>?@ABCDEFGHIJLMNOQRSTVWXY[\]^`abcdefghijklmnopqrstuvwxyz{|}~8:H 枈:#xp本 @槆厗2FW荙 ;@儣Z膻B2xW荙 ;@儣Z膻B2鱬本 @槆厗2ME0P[LSS>"<8<N0{00020819-0000-0000-C000-000000000046}p  *p`Xo 2`Xo i4  %j(`p@凗%偁$%x`,@ @ @8 @ @ @ @ x @` @X ($6 p Pp_)S$*\Rffff*0:5eaadd1b*\R1*#275*\R1*#274h  "  8 " @ H"P "`   ( V08 @ X x    x]  ` ,!.$,(0o@p0 ( '(ActiveWindow.Visible = Falsex ( $B@6!MsgBox "比賽報名表自動保存成功！"d(PMsgBox "請確認報名信息,然後發送至比賽規定的郵箱♑️！", vbOKOnly, "歡迎使用索美軟件"koPublic a As StringSub aa(bb As Integer) a = "public1"MsgBox aEnd SubMsgBox Str(bbbbb + 1) Call aa(1)IAttribute VB_Name = "ThisWorkbook" 孊as0{00020P819-0C$0046} |GlobalSpac扚alse dCreatablPred恊claIdTru BExposeTemplateDeriv払ustomizD2Option /licitPub b As I纍teger /A3 Sub 叏_Open() O#rror R坋su糔ex'Windows(.Count)`.Visi垉CE nd*2BeforeCl(CancelMBoo發ean>0=2+ 1 'Ac瀟I#!DLIf = 1 Then 墢.Savf'MsgBox "比賽報磣遠４娉曬Γ±塃聛F 請啡狹 信息,然後發橢羴規定@的郵箱, vbOKOnly, "歡迎使用索美0軟件JIf\ 圠5Dma丒S羘g羒aa(渂bA膓K'a伵jp聐1@ *a縺 F@S 繮ACall @1rU@@8P ! "pAq/h ` `iIY)gg gxvlVXX.Xg?82Xgg g"`q`g`q>pg Z0vggg8 `h Z Zh"a"arU@@@8Q`8@!`@C*@p`bfff*0;5eaadd1b*\R1*#3c7*\R1*#12d*\R0*#17*\R0*#14*\R1*#11c`\ " & 0 *H x  " (  ( 6H  B  J0 (  HX0` (x "0 (  ( D0 6@ &P (x  * " . HXb` b b b (8b@ `p x,L 6 & ,M枈T #pJ 艑6錎窰g FO蔑&櫘鼴83鰣亨xO蔑&櫘鼴83鰣亨J 艑6錎窰gMEP[LSS8>6"LLRXZ@P @`8 @H0 @L @  @P棹 @玄 X@叁 @俐 @羹 @剝o 8@H橚 @ @xh @xP @`8 @懸 L@更 L@ 狘 8L@H堻 8 L@ @h @P @8 @ @ @@ @棼 @ 宣 @耕 ` \@p狖 H`@堺 p`@p `@0 X `H p@ @ @( ( @X  @ @p 帔 @ 鰓 @ 苞 @ 橔 @ @h @ P @ 8 @ @X 礫 p 0 @ X @ 慁 @ x @~` @ H ( @H 0 8  `  @p  H @  p p @ 桫 @ 續 @0 給 H  @h 狓 X 0 0 @ 堷 h @ p @ X  @( @ @ @P ( h ( @x  P @ x @ 圜 @灑  @8鎊 (P@`橑 x8@ ``@h @P @ 8 8@  H X P @ @瘀 @p倀 @麗 @p H@0愽 @場 @p @hX @@ p@( `HxH <%p>R@ @ @ @ @0 @x @L` @pH @0 @P @  @  @ 瘙 8 @棹 `  @h幗o H @@叁 @B剝 H@橚 @ @h @0P H@h8 X00@ h@ @瘕  @槧 0 @@幘 X @佚 @ @旋o h @Dp庚 h(@狚 )@堼 )@@p 0)X+@hX @,@@ h,h.@( @ ((px`_)S*\R1*#278$*\Rf (HPX`h,p FVJ T@`J hTJ T0PJ XTJ T @  H X ` 8p V J  T  J  Tp  J  T  J  T`  J  T      8 X x  <       @ <L  6  *@BPh@p @ @ @ 8H@P p <^ 6 0 B( @ VXxTT@ ""b  @P X"hb  "b  "(b@ `p x"b   $ 6^  6Xhp x 0 2VT T@@` "x"b  "b 8H P"`bx  "b  " b8 Xh p $ 6^ 6  * TPBhB "p 8H P$X`TZ  "(p@  $XTZ    "   TTB (B8BP hJx0 0   "  <H&VZ&JZ  (J80P hx"0 &VZ&J ZHh 0pB    j P h 8  > 4 P hp  4! 8! jX! ! !  ! "] 加速創建報名$If Range("P37").Value <> "比賽" ThenExit SubEnd Ifcurline = ActiveCell.Rowcurxmname = ActiveCell.Value!If Range("B" & curline) = "" ThenActiveCell.Value = ""Range("B" & curline) = ""0MsgBox "輸入運動員姓名,然後才可以選擇參賽項目🍰！"End If -------------T2$>!N'L L----------查找關鍵字的行號 P R!T P!N男子姓名!Sheet2.Cells(i, 1).Value = cc.Row P!V'@k P!N女子姓名!Sheet2.Cells(i, 1).Value = cc.Row P!V'BkH P!N電子報名補充說明:!Sheet2.Cells(i, 1).Value = cc.Row P!V'Dyk X!V'F X!N'HMsgBox "男子開始行:" & manstart!MsgBox "女子開始行:" & womenstartMsgBox "結束行:" & endline$MsgBox "當前單元格的行號:" & curlineMsgBox "當前值:" & curxmname'-----------------當前行項目名稱重復次數 H'JC F$> H J 'JkhD F$> H J 'Jk0E F$> H J 'JkF F$> H J 'JkG F$> H J 'Jk J "同一名運動員重復報相同的比賽項目！A@Z X(N'Jk(k -----------------是否與全能沖突]('\'^]@Xp'`'b'd'f'h]0H男子 F @ F B  j D D N j$>!NC F$>N j$>!NQ j$>!N'`kN j$>!ND F$>N j$>!NQ j$>!N'bk N j$>!NE F$>N j$>!NQ j$>!N'dkN j$>!NF F$>N j$>!NQ j$>!N'fk0N j$>!NG F$>N j$>!NQ j$>!N'hk jk女子 F B F D j D D O j$>!NC F$>O j$>!NR j$>!N'`kO j$>!ND F$>O j$>!NR j$>!N'bkhO j$>!NE F$>O j$>!NR j$>!N'dkO j$>!NF F$>O j$>!NR j$>!N'fkxO j$>!NG F$>O j$>!NR j$>!N'hk jkMsgBox "xmid1:" & xmid1MsgBox "xmid2:" & xmid2MsgBox "xmid3:" & xmid3MsgBox "xmid4:" & xmid4MsgBox "xmid5:" & xmid5 ` b  d  f  h '\k ` `d b bd d dd f fd h hd'^k` \ ^2同一名運動員不能同時參加全能項目和其它單項的比賽👏🏿✍️！A@Z X(Nk#-----------------運動員限報數量檢測]`xS3$>!N'z'x ` `d x 'xkX b bd x 'xk  d dd x 'xk f fd x 'xk h hd x 'xkx x z 每名參賽運動員限報🌄： z個單項,可兼報接力!A@Z X(Nk*-----------------參賽單位限報數量檢測-男子]S2$>!N'|MsgBox dwxbmax j D D 'p'rN j$>!N'lQ j$>!N'~ l ~dMsgBox "項目名稱:" & xmname t @ BC t$> l p 'pk t t @ BD t$> l p 'pkH t t @ BE t$> l p 'pk  t t @ BF t$> l p 'pk  t t @ BG t$> l p 'pk(  tMsgBox "當前男dwmax:" & dwmax p | 單項比賽🤵🏻👐，每個參賽單位限報🧠： |人!A@Z X(Nk k  j*-----------------參賽單位限報數量檢測-女子,Dim xmi, xmname, xmid, dwmax, ydymax, i1, i2 j D D 'p'rO j$>!N'lR j$>!N'~ l ~dMsgBox "項目名稱:" & xmname t B DC t$> l p 'pk  t t B DD t$> l p 'pk  t t B DE t$> l p 'pkP  t t B DF t$> l p 'pk  t t B DG t$> l p 'pk  tMsgBox "當前女dwmax:" & dwmax p | 單項比賽，每個參賽單位限報： |人!A@Z X(Nkk j#-----------------參賽單位總人數限報T2$>!NU2$>!N'U3$>!N'男子規則' t @ BH t$>$H t$>H t$>比賽B t$>   'k t       B R%B@違反報名規則：男子限報： 人；實際報了： 人，自動刪除一行！A@Zk女子規則' t B DH t$>$H t$>H t$>比賽B t$>   'k8 t       D R%B@違反報名規則：女子限報： 人🎅🏼；實際報了🧑🏻‍🦰➔： 人，自動刪除一行！A@Zkxkhk`oX 加速創建報名P37$>!N比賽|kT2$>!NT2$>!N'L LU2$>!N'U3$>!N'男子 P R!T P!N男子姓名 P!V'@k@ P!N女子姓名 P!V'BykMsgBox "行數:" & manstartMsgBox "行數:" & womenstart6MsgBox "行數:" & manlingsmax - (womenstart - manstart)   B @   @ R%B@(  B @    @ R%B@女子 P R!T P!N女子姓名 P!V'Bk P!N電子報名補充說明: P!V'Dy@k80   D B   B R%B@  D B    B R%B@ (T2$>(Nk`kX禁止使用插入列功能On Error Resume NextcApplication.CommandBars("Worksheet Menu Bar").Controls("插入(I)").Controls("列(C)").Enabled = FalseOn Error GoTo 0禁止使用插入列功能1Application.CommandBars("Column").Enabled = False禁止使用插入行功能判斷7If Range("U2").Value = 0 And Range("U3").Value = 0 Then-Application.CommandBars("row").Enabled = TrueOn Error Resume NextbApplication.CommandBars("Worksheet Menu Bar").Controls("插入(I)").Controls("行(R)").Enabled = TrueOn Error GoTo 0Else.Application.CommandBars("row").Enabled = FalseOn Error Resume NextcApplication.CommandBars("Worksheet Menu Bar").Controls("插入(I)").Controls("行(R)").Enabled = FalseOn Error GoTo 0End Ifo毜Attribute VB_Name = "She@et1" 鐱ast0{00020820- C$0046} |Global!腟pac扚alse dCreatablPre declaId玊ru BExposeTemplateDeriv$払ustom宨zD2 P Sub Works亾_Change(ByVal Target As R ) Dim manstart, womeendline, curxmn, maxxm '加速創建惐If.("P37").;ue <> "比賽" Th別nExitUnd If4淎ctCel鄉.Row B" &,) "F$罀2'侭("MsgBox "輸入運動員姓名,然蟛趴梢匝≡癲穩狀目！EE3B- ad罶s0valiADT2賲H 1 1EK查找關鍵字的行號 For Each cc In 9.U@cccLike "男子A3H 2.A]s(i, 1o=胊厞V@蟼f;@/ 女/G!電子酦補充說明:焽$\ 丷) 繬ext S 鵕錑a-開始喧 &&n(L%( 醜結束$d當前單元<格C 值?ciUb 行罿名稱重 創問Hur遜%.F傕)0D\>C,rG&C g+ 10`K D e摶 E F ; G Т > E%R同一鹀殹;報相蛒膩磫橳+=. @=ee'嶪是否與全能沖突ＮqneHxis蝑x > $鉍Qjxm爄d1, a2c3c4c5 "Wb3457an襪, dw$, ydy錼ii221___=?1__RJ81___W?1__R817_V?1'鍁癧d1颮棐`d2f33<44>50q92A40 Or 23z45:wz+(cP50抙= 100)q2& 3xmid3 <= 100) Or (4 <> 0 And 8 5 @Then dxexisDt ( E奍f If qn.N 9MsgBox "同幻碩輩荒芡輩渭尤芟钅亢推淥ハ畹謀熱" ActiveCell.Val4ue"'- _限報數量檢測 Dim ydyd纗bmzs,pax *Range("S3")40v齻1  4+ 1 泜$2$$鲏顕僠$謮n7斻$G >苖虝每@名參賽G~" & & "個習,可兼報接力!駯!A單位I-娜兇觾榙w摾首E2G'拿F ` For謇 endline +@ 3 To 15@燿wmax@ 繣xmnam{A艱N|Yi鰀@DQM y绖""鋭 c壞."av名稱:c Aa i1` mansta剅t!womeb $Ci1)M "hE@Next ik` D骺lE轋G芃當前男b"N" > ?刯DU呄偸x扛 y儏`吶藖僠t ePQ n 覓喤畞唙'永,羐i a穴s cSheet. Rows(谼- 1).DeletcN%違反報涿♦️：Qa胓h✸；實際p報了 自動刪除愐恍衎 '1裡; _x 爪O髵袿("5O鴟COObC b搹nt> r叨/ee擁q:`強漩 'G鋺D#SubACPrivate Sub Worksheet_SelectionChange(ByVal Target As RT) '加速唇ū  If@("P37").vue <> "比賽" Then 0Exit ndH If 7T26= 00addlinsvalid >=b*@ $;ma俷;gsmax:Ue wome5e 3Du'兇For Each cc In A晇eS.Used弫 刢cLike " 姓名厒 MstartKRowE 2 !女子? !^"伆U (Next'MsgBox "行數:" &F"SV褑X- ($-F孡 O僫ei=1 To + N1塠繩s(哖+ 2).Inser8:Q( - 1)@#`D它te Wis奀貖電子宀鉤淥得骼y en佊e薔:F(<@%鉬> -z '@)67g@7= ( E7B %A0蜤7Applica釤.Scre enUpdng1%Tru ="|("陻`S舦g'禁故褂貌迦肓泄δ蔦On Err圧@esume 臚 D 'ComQd@Bars("Τ `Menu @揅纎ntrol (I)j列(C!Enable仸PFals'G:o爋0@Coplumn O 嗅判斷 鍬*0 AX*U姝"cUw"rowj33+an++行(R++E.) 4??rE ""饍醼__SRP_4>__SRP_5 PSheet2P__SRP_6J6gT KDgB `g`K>gB HgB  0gJZH幗g0 xl@g 叁gg0 xlg 剝g幗gg幗gV橚H剝叁xhh8gZ叁Z$-g橚8gJ橚剝叁xH<gZ叁Z$%g橚gJZH瘕瘕~-旋Lg0 xlg 剝gg0 xl0g 庚g旋Lgg旋gV橚0庚剝x狚狚pgZ剝Z$-g橚pgJ橚庚剝x0@gZ剝Z$%g橚@\g0 8*+gB gggT幗旋槧hP8 瘕狚堼pX@庚叁剝橚H`0,x`rU@@80. a!q aAa1Qq!AAq!Q !1a Q ` 1A  ``ii9v1.ggB08P 00gPK.gJ0Z0H玄玄棹0剝g0棹P 橚lg棹 gg0棹P 橚lVg棹 gg0棹P 橚lg棹 g剝gg棹剝gD0ZP0lP0g60ZP00gP \gPhgb08PO 0橚K0橚g hPhggb08PO 0橚K0橚g hPhggb08PO 0橚K0橚g hPhggb08PO 0橚K0橚g hPhggb08PO 0橚K0橚 g hPhgghPgL8橚PI(橚8g6P 0ZP00gPhgggP gPgP瘕gP佚gP例gPgP慅gFP橚e78lgVP更更x8橚懸懸堻g 08PxO 0PhO橚 8Ch PxO8 棼 T宣7耕l0 橚88棼lgT08PxO 0橚瘕0gg 08PxO 0PhO橚 8Ch PxO8 棼 T宣7耕l0 橚88棼 gT08PxO 0橚佚0gg 08PxO 0PhO橚 8Ch PxO8 棼 T宣7耕l0 橚88棼4 gT08PxO 0橚例0gg 08PxO 0PhO橚 8Ch PxO8 棼 T宣7耕l0 橚88棼 gT08PxO 0橚0gg 08PxO 0PhO橚 8Ch PxO8 棼 T宣7耕l0 橚88棼 gT08PxO 0橚慅0ggx堻gg8e橚7lgVP堺堺x8橚狖狖Xg 08PxO 0PhO橚 8Ch PxO8 棼 T宣7耕l0 橚88棼 gT08PxO 0橚瘕0gg 08PxO 0PhO橚 8Ch PxO8 棼 T宣7耕l0 橚88棼ngT08PxO 0橚佚0gg 08PxO 0PhO橚 8Ch PxO8 棼 T宣7耕l0 橚88棼gT08PxO 0橚例0gg 08PxO 0PhO橚 8Ch PxO8 棼 T宣7耕l0 橚88棼6gT08PxO 0橚0gg 08PxO 0PhO橚 8Ch PxO8 棼 T宣7耕l0 橚88棼gT08PxO 0橚慅0ggxXgg瘕P佚8橚+例h8+hP8+棼慅P宣+耕ldgP gg 瘕PT瘕8de橚7佚hT8佚Pdeh78+棼例PT宣例 de耕7@+(Tde帔7鰓+苞慅橔T慅hdeP78+ lgPgg@ PC8C橚7lfgL8橚PI(橚8g6P 0ZP00ggB08P 0瘞0gPg@瘕PT瘕8de橚7l"g Pgg@佚PT佚8de橚7lg Pgg@例PT例8de橚7lg Pgg@PT8de橚7lTg Pgg@慅PT慅8de橚7lg Pgg瘞ng^h8P瘞O8O橚( 橚8hg6P 0ZP00ggB08P 0佇0gVPx8橚礫礫x!gP0gPgT08PxO 0橚`0gT08PxO 0橚`0g@`P T`8de橚7l!g"0gb08PO 0橚`K0橚g 0P0gg0>g"gb08PO 0橚`K0橚g 0P0ggg"續\gb08PO 0橚`K0橚@g 0P0gg續g"狓 gb08PO 0橚`K0橚 g 0P0gg狓~g"p gb08PO 0橚`K0橚 g 0P0ggp> g0佇!g^h8P佇O8O橚( 橚8hg6P 0ZP00gggxx gVP@@x8橚XX'gP0gPgT08PxO 0橚`0gT08PxO 0橚`0g@`P T`8de橚7l'g"圜#gb08PO 0橚`K0橚#g 0P0gg圜4#g"鎊$gb08PO 0橚`K0橚v$g 0P0gg鎊#g"R%gb08PO 0橚`K0橚6%g 0P0gg$g"P&gb08PO 0橚`K0橚%g 0P0ggPt%g" &gb08PO 0橚`K0橚&g 0P0gg 4&g0佇'g^h8P佇O8O橚( 橚8hg6P 0ZP00gggx"gT08P 0hK0.gB08P 00gB08P  0瘀0gP倀g"r*g08P!O e0r橚[ Ph!O 8P Ch+8!O棼 宣橔"C耕+@場愽h#O( 場K帔p鰓7苞l場橚8 棼宣(V*g 倀P倀gg(gX倀倀P橚7887hl+gTP0Z0$%0g棼8hP&O8'O橚倀Oh(O8(橚8h8棼ggPXg"(-g08P!O e0r橚[ Ph!O 8P Ch+8!O棼 宣橔"C耕+@場愽h#O( 場K帔p鰓7苞l場橚8 棼宣(-g XPXgg(+gXX瘀XP橚7887hl.gTP0Z0$%0g棼8hP)O8'O橚倀Oh(O8(橚8h8棼gggg .J剝叁玄懸更狘堻狖堺pX礫慁xH0桫續給狓堷pX@(圜灑鎊橑hP8 麗@(瘕`H佚倀例` 瘞櫝慅h棹x0X佇瘀0場橚8h8棼宣耕@(帔鰓苞P8 PTggT, "\ngg"a "a`"a "aZrU@@@xH`8qH1`@qbrU@@@xH`8qH1`@1*#278$*\Rffff*0<5eaadd1c*\R1*#3c7*\R1*#12d*\R0*#17*\R0*#14`H " & 0 *H x  " (  ( 6H  B  J0 (  HX0` (x "0 (  ( D0 6@ &P (x  * " . HXb` b b b (8b@ `p x,L 6 &鰾枈v#p\q1皆灬F崶喢 毆 F己E丳L咠H 搳稥x己E丳L咠H 搳稥\q1皆灬F崶喢 毆MEH[LSS8>6"LRXZ@P @`8 @H0 @L @  @P棹 @玄 X@叁 @俐 @羹 @剝o 8@H橚 @ @xh @xP @`8 @懸 L@更 L@ 狘 8L@H堻 8 L@ @h @P @8 @ @ @@ @棼 @ 宣 @耕 ` \@p狖 H`@堺 p`@p `@0 X `H p@ @ @( ( @X  @ @p 帔 @ 鰓 @ 苞 @ 橔 @ @h @ P @ 8 @ @X 礫 p 0 @ X @ 慁 @ x @~` @ H ( @H 0 8  `  @p  H @  p p @ 桫 @ 續 @0 給 H  @h 狓 X 0 0 @ 堷 h @ p @ X  @( @ @ @P ( h ( @x  P @ x @ 圜 @灑  @8鎊 (P@`橑 x8@ ``@h @P @ 8 8@  H X P @ @瘀 @p倀 @麗 @p H@0愽 @場 @p @hX @@ p@( (((px`_)S*\R  (HPX`h,p FVJ T@`J hTJ T0PJ XTJ T @  H X ` 8p V J  T  J  Tp  J  T  J  T`  J  T      8 X x  <       @ <L  6  *@BPh@p @ @ @ 8H@P p <^ 6 0 B( @ VXxTT@ ""b  @P X"hb  "b  "(b@ `p x"b   $ 6^  6Xhp x 0 2VT T@@` "x"b  "b 8H P"`bx  "b  " b8 Xh p $ 6^ 6  * TPBhB "p 8H P$X`TZ  "(p@  $XTZ    "   (8P hx    "  <H&&  (8P hx" && Hh p   ] 加速創建報名$If Range("P37").Value <> "比賽" ThenExit SubEnd Ifcurline = ActiveCell.Rowcurxmname = ActiveCell.Value!If Range("B" & curline) = "" ThenActiveCell.Value = ""Range("B" & curline) = ""0MsgBox "輸入運動員姓名,然後才可以選擇參賽項目！"End If -------------T2$>!N'L L----------查找關鍵字的行號 P R!T P!N男子姓名!Sheet2.Cells(i, 1).Value = cc.Row P!V'@k P!N女子姓名!Sheet2.Cells(i, 1).Value = cc.Row P!V'BkH P!N電子報名補充說明:!Sheet2.Cells(i, 1).Value = cc.Row P!V'Dyk X!V'F X!N'HMsgBox "男子開始行:" & manstart!MsgBox "女子開始行:" & womenstartMsgBox "結束行:" & endline$MsgBox "當前單元格的行號:" & curlineMsgBox "當前值:" & curxmname'-----------------當前行項目名稱重復次數 H'JC F$> H J 'JkhD F$> H J 'Jk0E F$> H J 'JkF F$> H J 'JkG F$> H J 'Jk J "同一名運動員重復報相同的比賽項目！A@Z X(N'Jk(k -----------------是否與全能沖突]('\'^]@Xp'`'b'd'f'h]0H男子 F @ F B  j D D N j$>!NC F$>N j$>!NQ j$>!N'`kN j$>!ND F$>N j$>!NQ j$>!N'bk N j$>!NE F$>N j$>!NQ j$>!N'dkN j$>!NF F$>N j$>!NQ j$>!N'fk0N j$>!NG F$>N j$>!NQ j$>!N'hk jk女子 F B F D j D D O j$>!NC F$>O j$>!NR j$>!N'`kO j$>!ND F$>O j$>!NR j$>!N'bkhO j$>!NE F$>O j$>!NR j$>!N'dkO j$>!NF F$>O j$>!NR j$>!N'fkxO j$>!NG F$>O j$>!NR j$>!N'hk jkMsgBox "xmid1:" & xmid1MsgBox "xmid2:" & xmid2MsgBox "xmid3:" & xmid3MsgBox "xmid4:" & xmid4MsgBox "xmid5:" & xmid5 ` b  d  f  h '\k ` `d b bd d dd f fd h hd'^k` \ ^2同一名運動員不能同時參加全能項目和其它單項的比賽🏌🏽‍♀️！A@Z X(Nk#-----------------運動員限報數量檢測]`xS3$>!N'z'x ` `d x 'xkX b bd x 'xk  d dd x 'xk f fd x 'xk h hd x 'xkx x z 每名參賽運動員限報： z個單項,可兼報接力!A@Z X(Nk*-----------------參賽單位限報數量檢測-男子]S2$>!N'|MsgBox dwxbmax j D D 'p'rN j$>!N'lQ j$>!N'~ l ~dMsgBox "項目名稱:" & xmname t @ BC t$> l p 'pk t t @ BD t$> l p 'pkH t t @ BE t$> l p 'pk  t t @ BF t$> l p 'pk  t t @ BG t$> l p 'pk(  tMsgBox "當前男dwmax:" & dwmax p | 單項比賽👬🏼，每個參賽單位限報： |人!A@Z X(Nk k  j*-----------------參賽單位限報數量檢測-女子,Dim xmi, xmname, xmid, dwmax, ydymax, i1, i2 j D D 'p'rO j$>!N'lR j$>!N'~ l ~dMsgBox "項目名稱:" & xmname t B DC t$> l p 'pk  t t B DD t$> l p 'pk  t t B DE t$> l p 'pkP  t t B DF t$> l p 'pk  t t B DG t$> l p 'pk  tMsgBox "當前女dwmax:" & dwmax p | 單項比賽👨🏽✍🏽，每個參賽單位限報： |人!A@Z X(Nkk j#-----------------參賽單位總人數限報T2$>!NU2$>!N'U3$>!N'男子規則' t @ BH t$>$H t$>H t$>比賽B t$>   'k t       B R%B@違反報名規則：男子限報： 人；實際報了： 人👈，自動刪除一行！A@Zk女子規則' t B DH t$>$H t$>H t$>比賽B t$>   'k8 t       D R%B@違反報名規則🕵🏽‍♀️🧑‍🦳：女子限報： 人👨🏽‍🦰🛹；實際報了： 人，自動刪除一行👨‍🦼‍➡️！A@Zkxkhk`oX 加速創建報名P37$>!N比賽|kT2$>!NT2$>!N'L LU2$>!N'U3$>!N'男子 P R!T P!N男子姓名 P!V'@k@ P!N女子姓名 P!V'BykMsgBox "行數:" & manstartMsgBox "行數:" & womenstart6MsgBox "行數:" & manlingsmax - (womenstart - manstart)   B @   @ R%B@(  B @    @ R%B@女子 P R!T P!N女子姓名 P!V'Bk P!N電子報名補充說明: P!V'Dy@k80   D B   B R%B@  D B    B R%B@ (T2$>(Nk`kXoPH櫟Attribute VB_Name = "She@et2" 鐱ast0{00020820- C$0046} |Global!腟pac扚alse dCreatablPre declaId玊ru BExposeTemplateDeriv$払ustom宨zD2 P Sub Works亾_Change(ByVal Target As R ) Dim manstart, womeendline, curxmn, maxxm '加速創建惐If.("P37").;ue <> "比賽" Th別nExitUnd If4淎ctCel鄉.Row B" &,) "F$罀2'侭("MsgBox "輸入運動員姓名,然蟛趴梢匝≡癲穩狀目🧜🏻‍♂️！EE3B- ad罶s0valiADT2賲H 1 1EK查找關鍵字的行號 For Each cc In 9.U@cccLike "男子A3H.A]s(i, 1o=胊厞V@俧緡;@/ 女/G牏電子酦補忱淥得:O$\ 丷) N鄀xt S 鵕錑a-開始行 &&n(L%( hp結束$d鼻暗ピ烋C 值焎iUb 行罿名稱重復惔問Hurdo%.F傕)0D\C,rG&C g+ 1拽0`K D e摖轂 E F  G Т > E%R同一名c殹;報相同<的伌啓T+= @=ee'嶪是裼肴艹逋唬蝢nex$is蝑x $鉍QjxmiPd1, a2c3與4c5 "玝345an襪, d倃$, ydyr騣i221___=?1__RJ81___W?1__R81_沄?1'鍁癧d1R梬`d2f3U3<4450q92A40 TOr 234誡5:wz+(c P50抙= 100)q2& 3xmid3 <= 100) Or (4 <> 0 And 8 5 @Then dxexisDt ( E奍f If qn.N 9MsgBox "同幻碩輩荒芡輩渭尤芟钅亢推淥ハ畹謀熱" ActiveCell.Val4ue"'- _限報數量檢測 Dim ydyd纗bmzs,pax *Range("S3")40v齻1  4+ 1 泜$2$$鲏顕僠$謮n7斻$G >苖虝每@名參賽G~" & & "個習,可兼報接力!駯!A單位I-娜兇觾榙w摾首E2G'拿F ` For謇 endline +@ 3 To 15@燿wmax@ 繣xmnam{A艱N|Yi鰀@DQM y绖""鋭 c壞."av名稱:c Aa i1` mansta剅t!womeb $Ci1)M "hE@Next ik` D骺lE轋G芃當前男b"N" > ?刯DU呄偸x扛 y儏`吶藖僠t ePQ n 覓喤畞唙'永,羐i A穴S CSheet.Rows(窪- 1).DeletCN%違反報名：Qa鈍；實際報了 動刪除一湫蠦 &1眅; _x 乏Or袿("5O蟹#漁ObC b鋘t> r/麇eE縛sq:`懩 '' YFSub!PrUivate Sub Worksheet_SelectionChange(ByVal Target As RT) '加速創建報名 If2("P37").hue <> "比賽" Then Exitnd $If 7T26= 00addlinsvalid =b*@ $;manA;gsmax:Ue wome e 3D '男子For Each c@c In A抳eS仚.Used'倠刢cLike " 姓麉 Msta宺tKRow:E 2 !女 !^"伆U (Next'MsgBox "行朗:" &F"SGV哫- ($-3F缞 O僫eia=1 To 8+ 1塠繩s(哖+ 2).Inxser8:Q( - 1)@#`駾郎te Wis姧y貖電子宀鉤淥得嗺纘C en佊嫕:F(<@%鉬>榕 - '@)67g@7= ( E7B %A0蜤7Applica.ScreenUpd膎g%Tru ="|<("陻`S舦g !@獳"a "aZ1Qq!AAq!Q Q ` 1A __SRP_7 USheet3鵒__SRP_8J6__SRP_9ZrU@@80* a!q aAa1Qq!AAq!Q Q ` 1A  ``ii9v1.ggB08P 00gPK.gJ0Z0H玄玄棹0剝g0棹P 橚lg棹 gg0棹P 橚lVg棹 gg0棹P 橚lg棹 g剝gg棹剝gD0ZP0lP0g60ZP00gP \gPhgb08PO 0橚K0橚g hPhggb08PO 0橚K0橚g hPhggb08PO 0橚K0橚g hPhggb08PO 0橚K0橚g hPhggb08PO 0橚K0橚 g hPhgghPgL8橚PI(橚8g6P 0ZP00gPhgggP gPgP瘕gP佚gP例gPgP慅gFP橚e78lgVP更更x8橚懸懸堻g 08PxO 0PhO橚 8Ch PxO8 棼 T宣7耕l0 橚88棼lgT08PxO 0橚瘕0gg 08PxO 0PhO橚 8Ch PxO8 棼 T宣7耕l0 橚88棼 gT08PxO 0橚佚0gg 08PxO 0PhO橚 8Ch PxO8 棼 T宣7耕l0 橚88棼4 gT08PxO 0橚例0gg 08PxO 0PhO橚 8Ch PxO8 棼 T宣7耕l0 橚88棼 gT08PxO 0橚0gg 08PxO 0PhO橚 8Ch PxO8 棼 T宣7耕l0 橚88棼 gT08PxO 0橚慅0ggx堻gg8e橚7lgVP堺堺x8橚狖狖Xg 08PxO 0PhO橚 8Ch PxO8 棼 T宣7耕l0 橚88棼 gT08PxO 0橚瘕0gg 08PxO 0PhO橚 8Ch PxO8 棼 T宣7耕l0 橚88棼ngT08PxO 0橚佚0gg 08PxO 0PhO橚 8Ch PxO8 棼 T宣7耕l0 橚88棼gT08PxO 0橚例0gg 08PxO 0PhO橚 8Ch PxO8 棼 T宣7耕l0 橚88棼6gT08PxO 0橚0gg 08PxO 0PhO橚 8Ch PxO8 棼 T宣7耕l0 橚88棼gT08PxO 0橚慅0ggxXgg瘕P佚8橚+例h8+hP8+棼慅P宣+耕ldgP gg 瘕PT瘕8de橚7佚hT8佚Pdeh78+棼例PT宣例 de耕7@+(Tde帔7鰓+苞慅橔T慅hdeP78+ lgPgg@ PC8C橚7lfgL8橚PI(橚8g6P 0ZP00ggB08P 0瘞0gPg@瘕PT瘕8de橚7l"g Pgg@佚PT佚8de橚7lg Pgg@例PT例8de橚7lg Pgg@PT8de橚7lTg Pgg@慅PT慅8de橚7lg Pgg瘞ng^h8P瘞O8O橚( 橚8hg6P 0ZP00ggB08P 0佇0gVPx8橚礫礫x!gP0gPgT08PxO 0橚`0gT08PxO 0橚`0g@`P T`8de橚7l!g"0gb08PO 0橚`K0橚g 0P0gg0>g"gb08PO 0橚`K0橚g 0P0ggg"續\gb08PO 0橚`K0橚@g 0P0gg續g"狓 gb08PO 0橚`K0橚 g 0P0gg狓~g"p gb08PO 0橚`K0橚 g 0P0ggp> g0佇!g^h8P佇O8O橚( 橚8hg6P 0ZP00gggxx gVP@@x8橚XX'gP0gPgT08PxO 0橚`0gT08PxO 0橚`0g@`P T`8de橚7l'g"圜#gb08PO 0橚`K0橚#g 0P0gg圜4#g"鎊$gb08PO 0橚`K0橚v$g 0P0gg鎊#g"R%gb08PO 0橚`K0橚6%g 0P0gg$g"P&gb08PO 0橚`K0橚%g 0P0ggPt%g" &gb08PO 0橚`K0橚&g 0P0gg 4&g0佇'g^h8P佇O8O橚( 橚8hg6P 0ZP00gggx"gT08P 0hK0.gB08P 00gB08P  0瘀0gP倀g"r*g08P!O e0r橚[ Ph!O 8P Ch+8!O棼 宣橔"C耕+@場愽h#O( 場K帔p鰓7苞l場橚8 棼宣(V*g 倀P倀gg(gX倀倀P橚7887hl+gTP0Z0$%0g棼8hP&O8'O橚倀Oh(O8(橚8h8棼ggPXg"(-g08P!O e0r橚[ Ph!O 8P Ch+8!O棼 宣橔"C耕+@場愽h#O( 場K帔p鰓7苞l場橚8 棼宣(-g XPXgg(+gXX瘀XP橚7887hl.gTP0Z0$%0g棼8hP)O8'O橚倀Oh(O8(橚8h8棼gggg .J剝叁玄懸更狘堻狖堺pX礫慁xH0桫續給狓堷pX@(圜灑鎊橑hP8 麗@(瘕`H佚倀例` 瘞櫝慅h棹x0X佇瘀0場橚8h8棼宣耕@(帔鰓苞P8 Hi`"a "a`qbrU@@@xH`8qH1`@qb1Qq蘟 *\G{000204EF-01*#278$*\Rffff*0=5eaadd1d*\R1*#3c7*\R1*#12d*\R0*#17*\R0*#14`G " & 0 *H x  " (  ( 6H  B  J0 (  HX0` (x "0 (  ( D0 6@ &P (x  * " . HXb` b b b (8b@ `p x,L 6 &隑枈衋#p臥癭箈J托  F+紤)伯綶gx+紤)伯綶g臥癭箈J托 MEH[LSS8>6"LRXZ@P @`8 @H0 @L @  @P棹 @玄 X@叁 @俐 @羹 @剝o 8@H橚 @ @xh @xP @`8 @懸 L@更 L@ 狘 8L@H堻 8 L@ @h @P @8 @ @ @@ @棼 @ 宣 @耕 ` \@p狖 H`@堺 p`@p `@0 X `H p@ @ @( ( @X  @ @p 帔 @ 鰓 @ 苞 @ 橔 @ @h @ P @ 8 @ @X 礫 p 0 @ X @ 慁 @ x @~` @ H ( @H 0 8  `  @p  H @  p p @ 桫 @ 續 @0 給 H  @h 狓 X 0 0 @ 堷 h @ p @ X  @( @ @ @P ( h ( @x  P @ x @ 圜 @灑  @8鎊 (P@`橑 x8@ ``@h @P @ 8 8@  H X P @ @瘀 @p倀 @麗 @p H@0愽 @場 @p @hX @@ p@( (((px`_)S*\R  (HPX`h,p FVJ T@`J hTJ T0PJ XTJ T @  H X ` 8p V J  T  J  Tp  J  T  J  T`  J  T      8 X x  <       @ <L  6  *@BPh@p @ @ @ 8H@P p <^ 6 0 B( @ VXxTT@ ""b  @P X"hb  "b  "(b@ `p x"b   $ 6^  6Xhp x 0 2VT T@@` "x"b  "b 8H P"`bx  "b  " b8 Xh p $ 6^ 6  * TPBhB "p 8H P$X`TZ  "(p@  $XTZ    "   (8P hx    "  <H&&  (8P hx" && Hh p   ] 加速創建報名$If Range("P37").Value <> "比賽" ThenExit SubEnd Ifcurline = ActiveCell.Rowcurxmname = ActiveCell.Value!If Range("B" & curline) = "" ThenActiveCell.Value = ""Range("B" & curline) = ""0MsgBox "輸入運動員姓名,然後才可以選擇參賽項目☣️！"End If -------------T2$>!N'L L----------查找關鍵字的行號 P R!T P!N男子姓名!Sheet2.Cells(i, 1).Value = cc.Row P!V'@k P!N女子姓名!Sheet2.Cells(i, 1).Value = cc.Row P!V'BkH P!N電子報名補充說明:!Sheet2.Cells(i, 1).Value = cc.Row P!V'Dyk X!V'F X!N'HMsgBox "男子開始行:" & manstart!MsgBox "女子開始行:" & womenstartMsgBox "結束行:" & endline$MsgBox "當前單元格的行號:" & curlineMsgBox "當前值:" & curxmname'-----------------當前行項目名稱重復次數 H'JC F$> H J 'JkhD F$> H J 'Jk0E F$> H J 'JkF F$> H J 'JkG F$> H J 'Jk J "同一名運動員重復報相同的比賽項目！A@Z X(N'     @ !"#$%&'()*+,./02C3456789:;<=>?AEBDJk(k -----------------是否與全能沖突]('\'^]@Xp'`'b'd'f'h]0H男子 F @ F B  j D D N j$>!NC F$>N j$>!NQ j$>!N'`kN j$>!ND F$>N j$>!NQ j$>!N'bk N j$>!NE F$>N j$>!NQ j$>!N'dkN j$>!NF F$>N j$>!NQ j$>!N'fk0N j$>!NG F$>N j$>!NQ j$>!N'hk jk女子 F B F D j D D O j$>!NC F$>O j$>!NR j$>!N'`kO j$>!ND F$>O j$>!NR j$>!N'bkhO j$>!NE F$>O j$>!NR j$>!N'dkO j$>!NF F$>O j$>!NR j$>!N'fkxO j$>!NG F$>O j$>!NR j$>!N'hk jkMsgBox "xmid1:" & xmid1MsgBox "xmid2:" & xmid2MsgBox "xmid3:" & xmid3MsgBox "xmid4:" & xmid4MsgBox "xmid5:" & xmid5 ` b  d  f  h '\k ` `d b bd d dd f fd h hd'^k` \ ^2同一名運動員不能同時參加全能項目和其它單項的比賽🟫！A@Z X(Nk#-----------------運動員限報數量檢測]`xS3$>!N'z'x ` `d x 'xkX b bd x 'xk  d dd x 'xk f fd x 'xk h hd x 'xkx x z 每名參賽運動員限報： z個單項,可兼報接力!A@Z X(Nk*-----------------參賽單位限報數量檢測-男子]S2$>!N'|MsgBox dwxbmax j D D 'p'rN j$>!N'lQ j$>!N'~ l ~dMsgBox "項目名稱:" & xmname t @ BC t$> l p 'pk t t @ BD t$> l p 'pkH t t @ BE t$> l p 'pk  t t @ BF t$> l p 'pk  t t @ BG t$> l p 'pk(  tMsgBox "當前男dwmax:" & dwmax p | 單項比賽，每個參賽單位限報： |人!A@Z X(Nk k  j*-----------------參賽單位限報數量檢測-女子,Dim xmi, xmname, xmid, dwmax, ydymax, i1, i2 j D D 'p'rO j$>!N'lR j$>!N'~ l ~dMsgBox "項目名稱:" & xmname t B DC t$> l p 'pk  t t B DD t$> l p 'pk  t t B DE t$> l p 'pkP  t t B DF t$> l p 'pk  t t B DG t$> l p 'pk  tMsgBox "當前女dwmax:" & dwmax p | 單項比賽，每個參賽單位限報： |人!A@Z X(Nkk j#-----------------參賽單位總人數限報T2$>!NU2$>!N'U3$>!N'男子規則' t @ BH t$>$H t$>H t$>比賽B t$>   'k t       B R%B@違反報名規則：男子限報： 人；實際報了💒： 人👐🏿，自動刪除一行！A@Zk女子規則' t B DH t$>$H t$>H t$>比賽B t$>   'k8 t       D R%B@違反報名規則👮：女子限報： 人🦸‍♂️；實際報了⛹🏼‍♂️： 人☎，自動刪除一行！A@Zkxkhk`oX 加速創建報名P37$>!N比賽|kT2$>!NT2$>!N'L LU2$>!N'U3$>!N'男子 P R!T P!N男子姓名 P!V'@k@ P!N女子姓名 P!V'BykMsgBox "行數:" & manstartMsgBox "行數:" & womenstart6MsgBox "行數:" & manlingsmax - (womenstart - manstart)   B @   @ R%B@(  B @    @ R%B@女子 P R!T P!N女子姓名 P!V'Bk P!N電子報名補充說明: P!V'Dy@k80   D B   B R%B@  D B    B R%B@ (T2$>(Nk`kXoPH毜Attribute VB_Name = "She@et3" 鐱ast0{00020820- C$0046} |Global!腟pac扚alse dCreatablPre declaId玊ru BExposeTemplateDeriv$払ustom宨zD2 P Sub Works亾_Change(ByVal Target As R ) Dim manstart, womeendline, curxmn, maxxm '加速創建惐If.("P37").;ue <> "比賽" Th別nExitUnd If4淎ctCel鄉.Row B" &,) "F$罀2'侭("MsgBox "輸入運動員姓名,然蟛趴梢匝≡癲穩狀目！EE3B- ad罶s0valiADT2賲H 1 1EK查找關鍵字的行號 For Each cc In 9.U@cccLike "男子A3H 2.A]s(i, 1o=胊厞V@蟼f;@/ 女/G!電子酦補充說明:焽$\ 丷) 繬ext S 鵕錑a-開始喧 &&n(L%( 醜結束$d當前單元<格C 值?ciUb 行罿名稱重 創問Hur遜%.F傕)0D\>C,rG&C g+ 10`K D e摶 E F ; G Т > E%R同一鹀殹;報相蛒膩磫橳+=. @=ee'嶪是否與全能沖突ＮqneHxis蝑x > $鉍Qjxm爄d1, a2c3c4c5 "Wb3457an襪, dw$, ydy錼ii221___=?1__RJ81___W?1__R817_V?1'鍁癧d1颮棐`d2f33<44>50q92A40 Or 23z45:wz+(cP50抙= 100)q2& 3xmid3 <= 100) Or (4 <> 0 And 8 5 @Then dxexisDt ( E奍f If qn.N 9MsgBox "同幻碩輩荒芡輩渭尤芟钅亢推淥ハ畹謀熱" ActiveCell.Val4ue"'- _限報數量檢測 Dim ydyd纗bmzs,pax *Range("S3")40v齻1  4+ 1 泜$2$$鲏顕僠$謮n7斻$G >苖虝每@名參賽G~" & & "個習,可兼報接力!駯!A單位I-娜兇觾榙w摾首E2G'拿F ` For謇 endline +@ 3 To 15@燿wmax@ 繣xmnam{A艱N|Yi鰀@DQM y绖""鋭 c壞."av名稱:c Aa i1` mansta剅t!womeb $Ci1)M "hE@Next ik` D骺lE轋G芃當前男b"N" > ?刯DU呄偸x扛 y儏`吶藖僠t ePQ n 覓喤畞唙'永,羐i A穴S CSheet.Rows(窪- 1).DeletCN%違反報名🧑🏽‍🦲：Qa鈍🖕🏻；實際報了 動刪除一湫蠦 &1眅; _x 乏Or袿("5O蟹#漁ObC b鋘t> r/麇eE縛sq:`懩 '' YFSub!PrSivate Sub Worksheet_SelectionChange(ByVal Target As RT) '加速創建報名 If2("P37").hue <> "比賽" Then Exitnd $If 7T26= 00addlinsvalid =b*@ $;manA;gsmax:Ue wome e 3D '男子For Each c@c In A抳eS仚.Used'倠刢cLike " 姓麉 Msta宺tKRow:E 2 !女 !^"伆U (Next'MsgBox "行朗:" &F"SGV哫- ($-3F缞 O僫eia=1 To 8+ 1塠繩s(哖+ 2).Inxser8:Q( - 1)@#`駾郎te Wis姧y貖電子宀鉤淥得嗺纘C en佊嫕:F(<@%鉬>榕 - '@)67g@7= ( E7B %A0蜤7Applica.ScreenUpd膎g%Tru ="|<("陻`S舦g c獳"a "aZ!Q !Q ` 1A  ``ii_VBA_PROJECT_dir0__SRP_0 __SRP_1{rU@@8 * a!q aAa1Qq!AAq!Q !Q ` 1A  ``ii9v1.ggB08P 00gPK.gJ0Z0H玄玄棹0剝g0棹P 橚lg棹 gg0棹P 橚lVg棹 gg0棹P 橚lg棹 g剝gg棹剝gD0ZP0lP0g60ZP00gP \gPhgb08PO 0橚K0橚g hPhggb08PO 0橚K0橚g hPhggb08PO 0橚K0橚g hPhggb08PO 0橚K0橚g hPhggb08PO 0橚K0橚 g hPhgghPgL8橚PI(橚8g6P 0ZP00gPhgggP gPgP瘕gP佚gP例gPgP慅gFP橚e78lgVP更更x8橚懸懸堻g 08PxO 0PhO橚 8Ch PxO8 棼 T宣7耕l0 橚88棼lgT08PxO 0橚瘕0gg 08PxO 0PhO橚 8Ch PxO8 棼 T宣7耕l0 橚88棼 gT08PxO 0橚佚0gg 08PxO 0PhO橚 8Ch PxO8 棼 T宣7耕l0 橚88棼4 gT08PxO 0橚例0gg 08PxO 0PhO橚 8Ch PxO8 棼 T宣7耕l0 橚88棼 gT08PxO 0橚0gg 08PxO 0PhO橚 8Ch PxO8 棼 T宣7耕l0 橚88棼 gT08PxO 0橚慅0ggx堻gg8e橚7lgVP堺堺x8橚狖狖Xg 08PxO 0PhO橚 8Ch PxO8 棼 T宣7耕l0 橚88棼 gT08PxO 0橚瘕0gg 08PxO 0PhO橚 8Ch PxO8 棼 T宣7耕l0 橚88棼ngT08PxO 0橚佚0gg 08PxO 0PhO橚 8Ch PxO8 棼 T宣7耕l0 橚88棼gT08PxO 0橚例0gg 08PxO 0PhO橚 8Ch PxO8 棼 T宣7耕l0 橚88棼6gT08PxO 0橚0gg 08PxO 0PhO橚 8Ch PxO8 棼 T宣7耕l0 橚88棼gT08PxO 0橚慅0ggxXgg瘕P佚8橚+例h8+hP8+棼慅P宣+耕ldgP gg 瘕PT瘕8de橚7佚hT8佚Pdeh78+棼例PT宣例 de耕7@+(Tde帔7鰓+苞慅橔T慅hdeP78+ lgPgg@ PC8C橚7lfgL8橚PI(橚8g6P 0ZP00ggB08P 0瘞0gPg@瘕PT瘕8de橚7l"g Pgg@佚PT佚8de橚7lg Pgg@例PT例8de橚7lg Pgg@PT8de橚7lTg Pgg@慅PT慅8de橚7lg Pgg瘞ng^h8P瘞O8O橚( 橚8hg6P 0ZP00ggB08P 0佇0gVPx8橚礫礫x!gP0gPgT08PxO 0橚`0gT08PxO 0橚`0g@`P T`8de橚7l!g"0gb08PO 0橚`K0橚g 0P0gg0>g"gb08PO 0橚`K0橚g 0P0ggg"續\gb08PO 0橚`K0橚@g 0P0gg續g"狓 gb08PO 0橚`K0橚 g 0P0gg狓~g"p gb08PO 0橚`K0橚 g 0P0ggp> g0佇!g^h8P佇O8O橚( 橚8hg6P 0ZP00gggxx gVP@@x8橚XX'gP0gPgT08PxO 0橚`0gT08PxO 0橚`0g@`P T`8de橚7l'g"圜#gb08PO 0橚`K0橚#g 0P0gg圜4#g"鎊$gb08PO 0橚`K0橚v$g 0P0gg鎊#g"R%gb08PO 0橚`K0橚6%g 0P0gg$g"P&gb08PO 0橚`K0橚%g 0P0ggPt%g" &gb08PO 0橚`K0橚&g 0P0gg 4&g0佇'g^h8P佇O8O橚( 橚8hg6P 0ZP00gggx"gT08P 0hK0.gB08P 00gB08P  0瘀0gP倀g"r*g08P!O e0r橚[ Ph!O 8P Ch+8!O棼 宣橔"C耕+@場愽h#O( 場K帔p鰓7苞l場橚8 棼宣(V*g 倀P倀gg(gX倀倀P橚7887hl+gTP0Z0$%0g棼8hP&O8'O橚倀Oh(O8(橚8h8棼ggPXg"(-g08P!O e0r橚[ Ph!O 8P Ch+8!O棼 宣橔"C耕+@場愽h#O( 場K帔p鰓7苞l場橚8 棼宣(-g XPXgg(+gXX瘀XP橚7887hl.gTP0Z0$%0g棼8hP)O8'O橚倀Oh(O8(橚8h8棼gggg .J剝叁玄懸更狘堻狖堺pX礫慁xH0桫續給狓堷pX@(圜灑鎊橑hP8 麗@(瘕`H佚倀例` 瘞櫝慅h棹x0X佇瘀0場橚8h8棼宣耕@(帔鰓苞P8 Hi`"a "a`000-0000-C000-000000000046}#4.2#9#C:\PROGRA~1\COMMON~1\MICROS~1\VBA\VBA7.1\VBE7.DLL#Visual Basic For Applications*\G{00020813-0000-0000-C000-000000000046}#1.8#0#C:\Program Files\Microsoft Office\Office15\EXCEL.EXE#Microsoft Excel 15.0 Object Library*\G{00020430-0000-0000-C000-000000000046}#2.0#0#C:\Windows\System32\stdole2.tlb#OLE Automation(*\G{2DF8D04C-5BFA-101B-BDE5-00AA0044DE52}#2.7#0#C:\Program Files\Common Files\Microsoft Shared\OFFICE15\MSO.DLL#Microsoft Office 15.0 Object Library_)S枈ThisWorkbook0:5eaadd1b%ThisWorkbook: Sheet10;5eaadd1b9 Sheet1T 2M Sheet20<5eaadd1c Sheet2v0鼴 Sheet30=5eaadd1d Sheet3衋H馚hH0掆鲃2D栁(圪]^嵄" C睵K戲1i誸肂Gｄ]湮y襕訛簁sN埨搘贓蘺c]t8 Excel+` VBA麾`Win16羱`Win32`Win64x`Mac巢`VBA6#`VBA7#` VBAProject究`stdole揱`Officeu` ThisWorkbook|鉦 _Evaluate賎bbbbb6s` Workbook_Open涐`Windows`Count0v`Visible隊`Workbook_BeforeClose滄`Cancel駱`Save捫` Sheet1`Worksheet_Change烻`Target現`Range `manstart釘` womenstarti賎endlineq `curline$` curxmname甘` linemaxxmr` addlinsvalid崷`Value銴`cc荺` ActiveSheet%N` UsedRange葔`Row壪` ActiveCell椒`MsgBox桼`qnexist笪`dxexist8宍xmid1Pxmid2Qxmid3Rxmid4Sxmid5TxmiH颼xmname矪`xmid1隸dwmax)C`ydymax獌`i1揮`i2擼` ydydxbmzs煪`ydyxbmax`dwxbmax I`xmnameid≡` manlingsmax糽` womenlinesmax骮countmanbIsNull`Rows`Delete竫` countwomen-`Worksheet_SelectionChange4`addlinei8`Insert謗` Application*`ScreenUpdating! ` Sheet2` Sheet3`Sheet4`Sheet5`Sheet6`Sheet7`Sheet8`Workbookk` BeforeClose~;`_Defaultj耟 Worksheet窿`ChangeＧ`SelectionChange鉵`_B_var_addlinsvalid檫` _B_var_cco馺_B_var_xmnameid*琡_B_var_manlingsmax^`_B_var_womenlinesmax溓`_B_var_countman胝`_B_var_countwomenf渀_B_var_manstart閈`_B_var_womenstart擥`_B_var_addlineiS`_B_var_endline `l "% 9H,瞼0* pHd VBAProje坈t4@j = r _)S J< rstdole>stdole h%^*\G{00020430-C 0046}#2.0#0#C:\Windows\Syst em32\e2.tlb#OLE Automation`僂OffDic凟Ofic侲瀫攢丒2DF8D04C-5BFA-101B-BDE5E訟AC42圗gram Files\CommonMicrosoft Shared\OFFICE15\MSO.0DLL#僊 1@5.0 Ob伭 LibraryKE傇偍ThisWorkbookGT玦sW硆kbUo 2 QHB1Bx-B,!:*"B+BB|Sh爀et1GS@#俥@Xt1H2N2MTT 222I2鼴v333J3襇衋BU揔*rU@@@~ ~~~~~ ~~~~ ~ ~ ~ ~ ~ ~ ~f"Q0蓐 閭C%J祻 儕a 1 a 儕a1 q 儕a1 q 儕a1 q  VBAProject ThisWorkbookSheet1Sheet2Sheet3Sheet4Sheet5Sheet6Sheet7Sheet8F1C:\PROGRA~1\COMMON~1\MICROS~1\VBA\VBA7.1\VBE7.DLLVBA  aF4C:\Program Files\Microsoft Office\Office15\EXCEL.EXEExcel A0FC:\Windows\System32\stdole2.tlbstdole qL續-鶾藉D轗?C:\Program Files\Common Files\Microsoft Shared\OFFICE15\MSO.DLLOffice aFp本 @槆厗2FW荙 ;@儣Z膻B2DFWorkbook Workbook_OpenWorkbook_BeforeClose &mFFJ 艑6錎窰g FO蔑&櫘鼴83鰣亨DF WorksheetWorksheet_ChangeFFWorksheet_SelectionChange x T2:Q FFVBE7.DLL&mUsedRange Value 7uP[覻 TRow sYP[覻 T 5uP[ Te圗Q魦f:  C D E F G " TN T袕≧XT蛻 Y鴙 T剉詋[峺橆v NS (~ Q O R 2 TN T袕≧XT N齹 T鰁耂燫hQ齹y橆v孴vQ僛USy槃v詋[ S3 蟢 T耂[嵭彣RXTP枼b *NUSy,颯|Q汻! S2 篘 陙≧ RdNL USy樤k[ 蟢*N耂[峌SMOP枼b 篘! U2 U3 H0 Z  詋[ BRows Delete 輳蚐 T膲R7uP[P枼b 篘瀃E枼b哊 輳蚐 T膲RsYP[P枼b\q1皆灬F崶喢 毆己E丳L咠H 搳稥臥癭箈J托 +紤)伯綶g[ 墤i砑N８顣暑灕冥讜X@劊鱵k蝚a jp.W乁h踭$&[SoO昻稲桱%^輒V匊模F応)蟻P﹄NyN窌と@>桵垨j鍇縪M萳JD`:b趈鰣b%b┆M!( 皟鳱篤窤(:僀 P37 Insert&mQ F&t Q!(mrU@@@@~~~r  bbbbbCancel  0  PTargetFThisWorkbookThisWorkbookSheet1Sheet1Sheet2Sheet2Sheet3Sheet3ID="{00000000-0000-0000-0000-000000000000}" Document=ThisWorkbook/&H00000000 Document=Sheet1/&H00000000 Document=Sheet2/&H00000000 Document=Sheet3/&H00000000 HelpFile="" Name="VBAProjectPROJECTwmhPROJECTSummaryInformation(,DocumentSummaryInformation8" HelpContextID="0" VersionCompatible32="393222000" CMG="B6B41AF6261AB81EB81EBC22BC22" DPB="4C4EE06CE01FFD1FFDE00320FDAA9A70890F35511A01B525258982CAF3CFBA9588724346E52F" GC="E2E04E1AE51BE51B1A"[Host Extender Info] &H00000001={3832D640-CF90-11CF-8E43-00A0C911005A};VBE;&H00000000[Workspace] ThisWorkbook=44, 58, 716, 502, Sheet1=22, 29, 697, 472, Sheet2=44, 58, 719, 501, Sheet3=66, 87, 741, 530, Sheet4=88, 116, 763, 559, Sheet5=110, 145, 785, 588, Sheet6=132, 174, 807, 617, Sheet7=154, 203, 829, 646, Sheet8=0, 0, 675, 443, Z 鄥燆鵒h珣+'遲0 X`x 上海索美軟件上海索美軟件上海索美軟件lenovoMicrosoft Excel@E靖D@9q囕@  脹諟.摋+,0 PXd lt| slh 學生組教工組 教工益壯組 工作表 FMicrosoft Excel 2003 工作表Biff8Excel.Sheet.89瞦CompObjh