邢唷> WuxV  !"#$%&'()*+,-./0123456789:;<=>?@ABCDEFGHIJKLMNOPQRSTUYZ[\]^_`acmefghijklbnopqrstvwxyz{|}~Root Entry F=`鈍換犙X繡Workbook師_VBA_PROJECT_CUR"慃篯.犙a.犙VBA癳訽.犙?鮜.犙 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>媅SO""#,##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銄A} #0_ ;_ "ef_ @_ -}A} #0_ ;_ "ef_ @_ -}A} #0_ ;_ "ef_ @_ -}A} #0_ ;_ "ef_ @_ -}A} #0_ ;_ "ef_ @_ -}A} #0_ ;_ "ef _ @_ -}A} #0_ ;_ "蘈_ @_ -}A} #0_ ;_ "蘈_ @_ -}A} #0_ ;_ "蘈_ @_ -}A} #0_ ;_ "蘈_ @_ -}A} #0_ ;_ "蘈_ @_ -}A} #0_ ;_ "蘈 _ @_ -}A} #0_ ;_ "23_ @_ -}A} #0_ ;_ "23_ @_ -}A} #0_ ;_ "23_ @_ -}A} #0_ ;_ "23_ @_ -}A}  #0_ ;_ "23_ @_ -}A}! #0_ ;_ "23 _ @_ -}-}# #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 1G 20% - @wr 1 ef苕 % 20% - @wr 2G" 20% - @wr 2 ef蜍 % 20% - @wr 3G& 20% - @wr 3 ef腭 % 20% - @wr 4G* 20% - @wr 4 ef溥 % 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 3G' 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 3G( 60% - @wr 3 23淖 % 60% - @wr 4G, 60% - @wr 4 23睜 % 60% - @wr 5G0 60% - @wr 5 23捦 %! 60% - @wr 6G4 60% - @wr 6  23 %* 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,g褃膥抃xvzu膥刼Ye錧R梩^膥拏Ye錧-Nt^膥顢Ye錧蕍頧膥VV2g UJ詋[嵞~+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 Thu@|葽QAX虰 ccjB杶-z4n欰甠)k:~yw T8衫 3FI&S轞  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} } } } } @ }  } 3wwwwww                      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""""""""""""""""""""" !"#$%&'()*+,-./ 0  1  2   IB@@@@@@IBBB !\!] !S,!TTTTTTTTU "^_ "b"ccccccccd #^_ #b#eeeeeeeef # ! #" ## #$ #% $`a $g$hhhhhhhhi $ . $. $=$@@ % / %/ %>%5@5@ &K & 0 &0&6@6@ 'M'MMMMMMMMMM ' 1 '1'7@7@ (M(MMMMMMMMMM ( 2 (2(D@D@)NNNNNNNNNNN ) 3 )4)E@N@*MMMMMMMMMMM * 4 *5*N@繯@+MMMMMMMMMMM + 5 +7+繯@@R@,MMMMMMMMMMM , 6 ,8,R@@Y@-NNNNNNNNNNN - 7 -9-@R@Y@ . 8~ .@Y@ / 9~ /Y@ 0 :~ 0@^@ 1 ;~ 1@_@ 2 <~ 2_@*ph"B8~x@@^^RRRRR>@/*  ## $$      !!   !$"" '' (( -- )) ** ++ ,, 77  %$%  /  %$  /  %$  Sheet1b(b(  gghPh  (-  :S遅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 $ . $. $=$@@ % / %1 %>%5@7@ &K & 1 &4&7@N@ 'M'MMMMMMMMMM ' 4 '5'N@繯@ (M(MMMMMMMMMM ( 5 (7(繯@@R@)NNNNNNNNNNN ) 7 )8)@R@@Y@*MMMMMMMMMMM * 8~ *@Y@+MMMMMMMMMMM ,MMMMMMMMMMM -NNNNNNNNNNN ""B8~x@@^^R< >@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 jBkkkkkkkkl 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 $ . $. $=$@@ % / %/ %>%5@5@ &K & 1 &4&7@N@ 'M'MMMMMMMMMM ' 4 '5'N@繯@ (M(MMMMMMMMMM ( 5 (7(繯@@R@)NNNNNNNNNNN ) 7 )8)@R@@Y@*MMMMMMMMMMM * 8~ *@Y@+MMMMMMMMMMM + C~ +`@,MMMMMMMMMMM -NNNNNNNNNNN ""B8~x@@^^R<< >@NJ?''    !$!!    ++ ,, --  (( )) ** "" ## $$ 7/  %$ /  %$  7  %$%   Sheet3b(b(22gghTh  (-  :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 jEkkkkkkkkl 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 !\!] !SD!TTTTTTTTU "^_ "b"ccccccccd #^_ #b#eeeeeeeef # ! #" ## #$ #% $`a $g$hhhhhhhhi $ . $. $=$@@ % 1 %5 %>%7@繯@ &K & 5 &7&繯@@R@ 'M'MMMMMMMMMM ' 7~ '@R@ (M(MMMMMMMMMM )NNNNNNNNNNN *MMMMMMMMMMM +MMMMMMMMMMM ,MMMMMMMMMMM -NNNNNNNNNNN "R"B8~x@@H, >@NJ?''    !$!!    ++ ,, --  (( )) ** "" ## $$ 7/  %$ /  %$  7  %$%   Sheet4b(b(99gghTh  (-  :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 jGkkkkkkkkl 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 !\!] !SF!TTTTTTTTU "^_ "b"ccccccccd #^_ #b#eeeeeeeef # ! #" ## #$ #% $`a $g$hhhhhhhhi $ H $I $=$S@@S@ %> &K 'M'MMMMMMMMMM (M(MMMMMMMMMM )NNNNNNNNNNN *MMMMMMMMMMM +MMMMMMMMMMM ,MMMMMMMMMMM -NNNNNNNNNNN ""B8~x,, >@NJ?''    !$!!    ++ ,, --  (( )) ** "" ## $$ 7/  %$ /  %$  7  %$%   Sheet5b(b(11gghTh  (-  :S遅1_1_1 ThisWorkbook+ __SRP_25r__SRP_3 KSheet1dL  !"#$%&'()*+,-./012346789:;<=>?@ABCDEFGHIJLMNOQRSTVWXY[\]^`abcefghjklmnopqrstuvwxyz{|}~8:H 枈:#xLt2 C偠Rヰ艫F蚘S'qF嗗菵虤俽x蚘S'qF嗗菵虤俽Lt2 C偠Rヰ艫ME0P[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:58e76cc1*\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.Xg82Xgg g"`q`g`q>pg Z0vggg8 `h Z Zh"a"arU@@@8Q`8@!`@C*@p`bpx`_)S*\R1*#278$*\Rffff*0;58e76cc1*\R1*#3c7*\R1*#12d*\R0*#17`; " & 0 *H x  " (  ( 6H  B  J0 (  HX0` (x "0 (  ( D0 6@ &P (x  * " . HXb` b b b (8b@ `p x,L 6:8P?枈T #p- O-鉑玤摢 F-*'遲巢A館钑LPkx-*'遲巢A館钑LPk- O-鉑玤摢MEP[LSS8>6"LN0{00020820-0000-0000-C000-000000000046}p :` kX)<x%@凘 @凚 @凞 @凢 @凥 @凧h @刓 @刕 @刞瘕 @刡佚 @刣例 @刦 @刪慅 @刯(x @刲` @刵XH @刾0 @剅 @則 @剉櫝 @剎 @剒H瘞 @剕佇 `GG)< % X(%凗 %偁8 %@ p0x@`(X <%p>RXZ@P @`8 @H0 @L @  @P棹 @玄 X@叁 @俐 @羹 @剝o 8@H橚 @ @xh @xP @`8 @懸 L@更 L@ 狘 8L@H堻 8 L@ @h @P @8 @ @ @@ @棼 @ 宣 @耕 ` \!N'@p狖 H`!N@堺 p`!N@p `!N'@0 X `!NH p$>@ @ @( ( @X  @ @p 帔 @ 鰓 @ 苞 @ 橔 @ @h @ P @ 8 @ @X 礫 p 0 j$@ X $>@ 慁 $>@ x j$@~` @ H ( @H 0 8  $>`  j$@p  H $>@  p $> p G F@ 桫 @ 續 j@0 給 H  1:" & @h 狓 X 0 id2 0 ox "xm@ 堷 h 4:" & @ p id5 b @ X  '\@( @ @ b@P ( h ( d@x  P @ x `@ 圜 運動員 加全能@灑  X@8鎊 (-----訮考觳@`橑 x8!N@ ``x@h @P d@ 8 8f@  H 'xX hP (( &  (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   ( " 0 8Ppx   0@H `px  " <&8X&`  " 0@HP&X&   ( 0 H jh   (0HxHHX` h x] 加速創建報名$If Range("P37").Value <> "比賽" Then%Exit 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'---------- M-------當前行項目名稱重復次數 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'|_B_vMsgBox 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 'p(kH t鸌旫' t @ B斣尮E t$> l p 'p,k  t  t @ B酤F t$> l  p 'p酤k  tL劄 t @ Bh,,G t$> l酤'% p 'p 恔(  t酤5軋MsgBox "當前男dwmax:" & dwmax p | :單項比賽，每個參賽單位限報： |人!A@Z: X(N k k  j *-----------------參賽單位限報數量檢測-女子,Dim xmi, xmname, xmid, dwmax, ydymax, i1, i2s j D D h'p'rO j$>!N'l酤a旫R j$>!N'~( l ~dMsgBox "項目名稱:" & xmname%!  t B D6軋C t$> l 匌 p 'p  t匌 t B D凝3D t$> l p 'p  t匎 t B D旫 $E t$> l$ p 'p鬹P  tH( t B D(F t$> l ( p 'p%k  t酤a t B D酤'%G t$> l p 'pk  t'匎MsgBox "當前女dwmax:" & dwmax匌 p | a旫單項比賽🤟🏽，每個參賽單位限報👨‍👩‍👦： |人!A@ZX X(N8kk j酤a旫ko 加速創建報名 匌P37$>!N比賽:|kT2$>!NT2$>!N'L訾 LXU2$>!N'%:U3$>!N'a旫男子6軋 P R!T P!N男子姓名 P!V'@%:k P!N女子姓名 P!V'BykxMsgBox "行數:" & manstartMsgBox "行數:" & womenstart匎T 6MsgBox "行數:" & manlingsmax - (womenstart - manstart)   B @    @ R%B@l  B @     @ R%B@P女子踐 P R!T P!N女子姓名 P!V'B潺k P!N電子報名補充說明:瀨 P!V'Dyk   D B    B R%B@@X  D B    鸃 B R%B@%!  (]3TT2$>(N%! 恔k禁止使用插入列功能On Error Resume NextcApplication.CommandBars("Worksheet Menu Bar").Controls("插入(I)").Controls("列(C)").Enabled = False4FOn Error GoTo 0A4禁止使用插入列功能Column %(寧禁止使用插入行功能判斷hU2$>!NU3$>!Nrow %(h行(R)插入(I)Worksheet Menu Bar %%%(drow %(行(R)插入(I)Worksheet Menu Bar %%%(ko毜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& 3Uxmid3 <= 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 覓喤畞唙'永,羐iFBL緄纮悕gsMT>Ux9翉, '訓C咵ach 燾c InS1.UsedA.KccっLike B"姓名U v=.Row%R,裑+鐳J?@1 盇+行+(GG&- (8 -O6"cei1鱭W魵 fs/3s(+ 2).Inser~t丄 壟-^ 罓2 wD齪2tre#v"鍩"觨4"a &電子A9補赤淥得鱬eN戰#or'(ob er3p脖endline - womenstart) + 1 ActiveSheet.Rows(2).Inser"tTNexFor ad = 1 To (1)俿max"tDeletetApplication.Scr@eenUpdn"gTru*Range("T2").Value End If '禁止使用插入列功能 'On ErrlResume v ' >CommandBars(@"Works仠 `Menu =C纎ntrol/(I) 列(CEnabledaQFals_@G:o0I慡朎Coplumn5,#;判斷 If MU M0 A繪E3匰0 T hen !ro>wJ Cf梀pV行(RKVL臮E耓0膅?11F1實Sub伕__SRP_4P.__SRP_5 PSheet2 L__SRP_6P.`"a "aZ aq Aa1Qq!AAq Q rU@@@xH`8qH1`@qb9 *rU@@@xH`8qH1`@rU@@80 aq Aa1Qq!AAq Q ` 1A  ``ii9 *'ggB08P 00gPK'gJ0Z0H玄玄棹0剝g0棹P橚lg棹 gg0棹P 橚lVg棹 gg0棹P 橚lg棹 g剝gg棹剝gD0ZP0lP0g60ZP00gP \gPhgb08P O 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 0Ph O橚 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 0Ph O橚 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"0gb08P O 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"圜#gb08P O 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"gg'B剝叁玄懸更狘堻狖堺pX礫慁xH0桫續給狓堷pX@(圜灑鎊橑hP8 瘕`H佚例` 瘞櫝慅h棹x0佇0橚8h8棼宣耕@(帔鰓苞P8 Hi`"a "apx`_)S*\R1*#278$*\Rffff*0<58e76cc2*\R1*#3c7*\R1*#12d*\R0*#17`; " & 0 *H x  " (  ( 6H  B  J0 (  HX0` (x "0 (  ( D0 6@ &P (x  * " . HXb` b b b (8b@ `p x,L 6:8P?枈v#p0;8肒☆M緄 F2讜#F'獢oKx2讜#F'獢oK0;8肒☆M緄MEP[LSS8>6"LN0{00020820-0000-0000-C000-000000000046}p :` kX)<x%@凘 @凚 @凞 @凢 @凥 @凧h @刓 @刕 @刞瘕 @刡佚 @刣例 @刦 @刪慅 @刯(x @刲` @刵XH @刾0 @剅 @則 @剉櫝 @剎 @剒H瘞 @剕佇 `GG)< % X(%凗 %偁 %@ p0x@`(X <%p===>RXZ==='=@P @`8 @H0 @L @  @P棹 @玄 XA>B>C>@叁 U>V>W>@俐 i>j>k>@羹 }>~>>@剝o 8>>>@H橚 >>>@ @xh @xP @`8 @懸 L>>>@更 L>>>@ 狘 8L?9?@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 (( &  (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   ( " 0 8Ppx   0@H `px  " <&8X&`  " 0@HP&X&   ( 0 H jh   (0HxHHX` h x]_ 加速創建報名 e$If Range("P37").Value <> "比賽" Then:_寚Exit 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 jko 加速創建報名P37$>!N比賽|kT2$>!NT2$>!N'L LU2$>!N'U3$>!N'男子 P R!T P!N男子姓名 P!V'@k P!N女子姓名 P!V'BykxMsgBox "行數:" & manstartMsgBox "行數:" & womenstart6MsgBox "行數:" & manlingsmax - (womenstart - manstart)   B @   @ R%B@  B @    @ R%B@P女子 P R!T P!N女子姓名 P!V'Bk P!N電子報名補充說明: P!V'Dyk   D B   B R%B@X  D B    B R%B@ (T2$>(Nkk禁止使用插入列功能On Error Resume NextcApplication.CommandBars("Worksheet Menu Bar").Controls("插入(I)").Controls("列(C)").Enabled = FalseOn Error GoTo 0禁止使用插入列功能Column %(禁止使用插入行功能判斷U2$>!NU3$>!Nrow %(h行(R)插入(I)Worksheet Menu Bar %%%(drow %(行(R)插入(I)Worksheet Menu Bar %%%(ko櫟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& 3Uxmid3 <= 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 覓喤畞唙'永,羐iFBL緄纮悕gsMT>Ux9翉, '訓C咵ach 燾c InS1.UsedA.KccっLike B"姓名U v=.Row%R,裑+鐳J?@1 盇+行+(GG&- (8 -O6"cei1鱭W魵 fs/3s(+ 2).Inser~t丄 壟-^ 罓2 wD齪2tre#v"鍩"觨4"a &電子A9補赤淥得鱬eN戰#or'(ob er3p脖endline - womenstart) + 1 ActiveSheet.Rows(2).Inser"tTNexFor ad = 1 To (1)俿max"tDeletetApplication.Scr@eenUpdn"gTru*Range("T2").Value End If '禁止使用插入列功能 'On ErrlResume v ' >CommandBars(@"Works仠 `Menu =C纎ntrol/(I) 列(CEnabledaQFals_@G:o0I慡朎Coplumn5,#;判斷 If MU M0 A繪E3匰0 T hen !ro>wJ Cf梀pV行(RKVL臮E耓0膅?11F1實Sub伕`"a "aZ1Qq!AAq Q ` 1A  ``ii__SRP_7 USheet3L__SRP_8P.__SRP_9ZrU@@8 aq Aa1Qq!AAq Q ` 1A  ``ii9 *'ggB08P 00gPK'gJ0Z0H玄玄棹0剝g0棹P橚lg棹 gg0棹P 橚lVg棹 gg0棹P 橚lg棹 g剝gg棹剝gD0ZP0lP0g60ZP00gP \gPhgb08P O 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 0Ph O橚 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 0Ph O橚 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"0gb08P O 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"圜#gb08P O 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"gg'B剝叁玄懸更狘堻狖堺pX礫慁xH0桫續給狓堷pX@(圜灑鎊橑hP8 瘕`H佚例` 瘞櫝慅h棹x0佇0橚8h8棼宣耕@(帔鰓苞P8 Hi`"a "aqbrU@@@xH`8qH1`@qb1QqrU@@@ px`_)S*\R1*#278$*\Rffff*0=58e76cc3*\R1*#3c7*\R1*#12d*\R0*#17`; " & 0 *H x  " (  ( 6H  B  J0 (  HX0` (x "0 (  ( D0 6@ &P (x  * " . HXb` b b b (8b@ `p x,L 6:8P?枈衋#p辟,鞄輦D牂4 <綘 F@+臒2C 癶3Ex@+臒2C 癶3E氨,鞄輦D牂4 <綘MEP[LSS8>6"LN0{00020820-0000-0000-C000-000000000046}p :` kX)<x%@凘 @凚 @凞 @凢 @凥 @凧h @刓 @刕 @刞瘕 @刡佚 @刣例 @刦 @刪慅 @刯(x @刲` @刵XH @刾0 @剅 @則 @剉櫝 @剎 @剒H瘞 @剕佇 `GG)< % X(Ms%凗 %偁 %@ p0x@`(X <%p>RXZ@P @`8 @H0 @L @  @P棹 @玄 X@叁 @俐 @羹 @剝o 8@H橚 韗@ @xh @xP @`8 @懸 L@更 L@ 狘 8L@H堻 8 L@ @h @P @8 @ @ @@ @棼 @ 宣 @耕 ` \!N'@p狖 H`!N@堺 p`!N@p `!N'@0 X `!NH p$>@ @ @( ( @X  @ @p 帔 @ 鰓 @ 苞 @ 橔 @ @h @ P @ 8 @ @X 礫 p 0 j$@ X $>@ 慁 $>@ x j$@~` @ H ( @H 0 8  $>`  j$@p  H $>@  p $> p G F@ 桫 @ 續 j@0 給 H  1:" & @h 狓 X 0 id2 0 ox "xm@ 堷 h 4:" & @ p id5 b @ X  '\@( @ @ b@P ( h ( d@x  P @ x `@ 圜 運動員 加全能@灑  X@8鎊 (-----訮考觳@`橑 x8!N@ ``x@h @P d@ 8 8f@  H 'xX hP (( &  (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   ( " 0 8Ppx   0@H `px  " <&8X&`  " 0@HP&X&   ( 0 H jh   (0HxHHX` h x] 加速創建報名S[峌SM$If Range("P37").Value <> "比賽" Then7Exit 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'----------    !"#$ &0()*+,-./%123456789:;<=>?@ABCDEFGHIJKOPQRSTUVWXYZ[\]^_`abcdLfphijklmnoeqrstuvwyz{|}~-------當前行項目名稱重復次數 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 jko 加速創建報名P37$>!N比賽|kT2$>!NT2$>!N'L LU2$>!N'U3$>!N'男子 P R!T P!N男子姓名 P!V'@k P!N女子姓名 P!V'BykxMsgBox "行數:" & manstartMsgBox "行數:" & womenstart6MsgBox "行數:" & manlingsmax - (womenstart - manstart)   B @   @ R%B@  B @    @ R%B@P女子 P R!T P!N女子姓名 P!V'Bk P!N電子報名補充說明: P!V'Dyk   D B   B R%B@X  D B    B R%B@ (T2$>(Nkk禁止使用插入列功能On Error Resume NextcApplication.CommandBars("Worksheet Menu Bar").Controls("插入(I)").Controls("列(C)").Enabled = FalseOn Error GoTo 0禁止使用插入列功能Column %(禁止使用插入行功能判斷U2$>!NU3$>!Nrow %(h行(R)插入(I)Worksheet Menu Bar %%%(drow %(行(R)插入(I)Worksheet Menu Bar %%%(ko毜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& 3Uxmid3 <= 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 覓喤畞唙'永,羐iFBL緄纮悕gsMT>Ux9翉, '訓C咵ach 燾c InS1.UsedA.KccっLike B"姓名U v=.Row%R,裑+鐳J?@1 盇+行+(GG&- (8 -O6"cei1鱭W魵 fs/3s(+ 2).Inser~t丄 壟-^ 罓2 wD齪2tre#v"鍩"觨4"a &電子A9補赤淥得鱬eN戰#or'(ob er3p脖endline - womenstart) + 1 ActiveSheet.Rows(2).Inser"tTNexFor ad = 1 To (1)俿max"tDeletetApplication.Scr@eenUpdn"gTru*Range("T2").Value End If '禁止使用插入列功能 'On ErrlResume v ' >CommandBars(@"Works仠 `Menu =C纎ntrol/(I) 列(CEnabledaQFals_@G:o0I慡朎Coplumn5,#;判斷 If MU M0 A繪E3匰0 T hen !ro>wJ Cf梀pV行(RKVL臮E耓0膅?11F1實Sub伕`"a "aZ aQ ` 1A  ``ii9 *'ggB08P Sheet4 'L__SRP_aNP.__SRP_b_Sheet5gLrU@@8 P aq Aa1Qq!AAq1 aQ ` 1A  ``ii9 *'ggB08P 00gPK'gJ0Z0H玄玄棹0剝g0棹P橚lg棹 gg0棹P 橚lVg棹 gg0棹P 橚lg棹 g剝gg棹剝gD0ZP0lP0g60ZP00gP \gPhgb08P O 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 0Ph O橚 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 0Ph O橚 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"0gb08P O 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"圜#gb08P O 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"gg'B剝叁玄懸更狘堻狖堺pX礫慁xH0桫續給狓堷pX@(圜灑鎊橑hP8 瘕`H佚例` 瘞櫝慅h棹x0佇0橚8h8棼宣耕@(帔鰓苞P8 Hi`"a "apx`_)S*\R1*#278$*\Rffff*0>58e76cc3*\R1*#3c7*\R1*#12d*\R0*#17`; " & 0 *H x  " (  ( 6H  B  J0 (  HX0` (x "0 (  ( D0 6@ &P (x  * " . HXb` b b b (8b@ `p x,L 6:8P?枈8m#p4雜鸤J琟@ F靋森 爊C檰籠@諵x靋森 爊C檰籠@諵4雜鸤J琟@MEP[LSS8>6"LN0{00020820-0000-0000-C000-000000000046}p :` kX)<x%@凘 @凚 @凞 @凢 @凥 @凧h @刓 @刕 @刞瘕 @刡佚 @刣例 @刦 @刪慅 @刯(x @刲` @刵XH @刾0 @剅 @則 @剉櫝 @剎 @剒H瘞 @剕佇 `GG)< % X(Ms%凗 %偁 %@ p0x@`(X <%p>RXZ@P @`8 @H0 @L @  @P棹 @玄 X@叁 @俐 @羹 @剝o 8@H橚 @ @xh @xP @`8 @懸 L345@更 LGHI@ 狘 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 (( &  (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   ( " 0 8Ppx   0@H `px  " <&8X&`  " 0@HP&X&   ( 0 H jh   (0HxHHX` h x] 加速創建報名$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 jko 加速創建報名P37$>!N比賽|kT2$>!NT2$>!N'L LU2$>!N'U3$>!N'男子 P R!T P!N男子姓名 P!V'@k P!N女子姓名 P!V'BykxMsgBox "行數:" & manstartMsgBox "行數:" & womenstart6MsgBox "行數:" & manlingsmax - (womenstart - manstart)   B @   @ R%B@  B @    @ R%B@P女子 P R!T P!N女子姓名 P!V'Bk P!N電子報名補充說明: P!V'Dyk   D B   B R%B@X  D B    B R%B@ (T2$>(Nkk禁止使用插入列功能On Error Resume NextcApplication.CommandBars("Worksheet Menu Bar").Controls("插入(I)").Controls("列(C)").Enabled = FalseOn Error GoTo 0禁止使用插入列功能Column %(禁止使用插入行功能判斷U2$>!NU3$>!Nrow %(h行(R)插入(I)Worksheet Menu Bar %%%(drow %(行(R)插入(I)Worksheet Menu Bar %%%(ko毜Attribute VB_Name = "She@et4" 鐱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& 3Uxmid3 <= 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 覓喤畞唙'永,羐iFBL緄纮悕gsMT>Ux9翉, '訓C咵ach 燾c InS1.UsedA.KccっLike B"姓名U v=.Row%R,裑+鐳J?@1 盇+行+(GG&- (8 -O6"cei1鱭W魵 fs/3s(+ 2).Inser~t丄 壟-^ 罓2 wD齪2tre#v"鍩"觨4"a &電子A9補赤淥得鱬eN戰#or'(ob er3p脖endline - womenstart) + 1 ActiveSheet.Rows(2).Inser"tTNexFor ad = 1 To (1)俿max"tDeletetApplication.Scr@eenUpdn"gTru*Range("T2").Value End If '禁止使用插入列功能 'On ErrlResume v ' >CommandBars(@"Works仠 `Menu =C纎ntrol/(I) 列(CEnabledaQFals_@G:o0I慡朎Coplumn5,#;判斷 If MU M0 A繪E3匰0 T hen !ro>wJ Cf梀pV行(RKVL臮E耓0膅?11F1實Sub伕`  "a "aZAa1Qq!AAq Q ` 1A xH `8qH1 `@qb 9 *rU@@@ xH `8qH1 `@qbrU@@8  aq Aa1Qq!AAq Q ` 1A  ``i i  9 *'ggB08P 00gPK'gJ0Z0H玄玄棹0剝g0棹P橚lg棹 gg0棹P 橚lVg棹 gg0棹P 橚lg棹 g剝gg棹剝gD0ZP0lP0g60ZP00gP \gPhgb08P O 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 0Ph O橚 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 0Ph O橚 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"0gb08P O 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"圜#gb08P O 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"gg'B剝叁玄懸更狘堻狖堺pX礫慁xH0桫續給狓堷pX@(圜灑鎊橑hP8 瘕`H佚例` 瘞櫝慅h棹x0佇0橚8h8棼宣耕@(帔鰓苞P8 Hi`  "a "apx`_)S*\R1*#278$*\Rffff*0?58e76cc3*\R1*#3c7*\R1*#12d*\R0*#17`; " & 0 *H x  " (  ( 6H  B  J0 (  HX0` (x "0 (  ( D0 6@ &P (x  * " . HXb` b b b (8b@ `p x,L 6:8P?枈z#p輺私$G｛&vd Fl4礔0杕N7xl4礔0杕N7呡柷私$G｛&vdMEP[LSS8>6"LN0{00020820-0000-0000-C000-000000000046}p :` kX)<x%@凘 @凚 @凞 @凢 @凥 @凧h @刓 @刕 @刞瘕 @刡佚 @刣例 @刦 @刪慅 @刯(x @刲` @刵XH @刾0 @剅 @則 @剉櫝 @剎 @剒H瘞 @剕佇 `GG)< % X(el%凗 %偁 %@ p0x@`(X <%pbcc>RXZc c c c c@P @`8 @H0 @L @  @P棹 @玄 Xgchcic@叁 {c|c}c@俐 廲恈慶@羹 @剝o 8穋竎筩@H橚 薱蘡蚦@ @xh @xP @`8 @懸 Lddd@更 L#d$d%d@ 狘 8L7d8d9d@H堻 8 LKdLdMd@ @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 (( &  (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   ( " 0 8Ppx   0@H `px  " <&8X&`  " 0@HP&X&   ( 0 H jh   (0HxHHX` h x] 加速創建報名$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 jko 加速創建報名P37$>!N比賽|kT2$>!NT2$>!N'L LU2$>!N'U3$>!N'男子 P R!T P!N男子姓名 P!V'@k P!N女子姓名 P!V'BykxMsgBox "行數:" & manstartMsgBox "行數:" & womenstart6MsgBox "行數:" & manlingsmax - (womenstart - manstart)   B @   @ R%B@  B @    @ R%B@P女子 P R!T P!N女子姓名 P!V'Bk P!N電子報名補充說明: P!V'Dyk   D B   B R%B@X  D B    B R%B@ (T2$>(Nkk禁止使用插入列功能On Error Resume NextcApplication.CommandBars("Worksheet Menu Bar").Controls("插入(I)").Controls("列(C)").Enabled = FalseOn Error GoTo 0禁止使用插入列功能Column %(禁止使用插入行功能判斷U2$>!NU3$>!Nrow %(h行(R)插入(I)Worksheet Menu Bar %%%(drow %(行(R)插入(I)Worksheet Menu Bar %%%(ko毜Attribute VB_Name = "She@et5" 鐱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& 3Uxmid3 <= 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 覓喤畞唙'永,羐iFBL緄纮悕gsMT>Ux9翉, '訓C咵ach 燾c InS1.UsedA.KccっLike B"姓名U v=.Row%R,裑+鐳J?@1 盇+行+(GG&- (8 -O6"cei1鱭W魵 fs/3s(+ 2).Inser~t丄 壟-^ 罓2 wD齪2tre#v"鍩"觨4"a &電子A9補赤淥得鱬eN戰#or'(ob er3p脖endline - womenstart) + 1 ActiveSheet.Rows(2).Inser"tTNexFor ad = 1 To (1)俿max"tDeletetApplication.Scr@eenUpdn"gTru*Range("T2").Value End If '禁止使用插入列功能 'On ErrlResume v ' >CommandBars(@"Works仠 `Menu =C纎ntrol/(I) 列(CEnabledaQFals_@G:o0I慡朎Coplumn5,#;判斷 If MU M0 A繪E3匰0 T hen !ro>wJ Cf梀pV行(RKVL臮E耓0膅?11F1實Sub伕__SRP_cP.__SRP_dd_VBA_PROJECTi+dirM`  "a "aZ!AAq !Q ` 1A  ``i i  9 *蘟 *\G{000204EF-0000-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\MicrosorU@@8  aq Aa1Qq!AAq !Q ` 1A  ``i i  9 *'ggB08P 00gPK'gJ0Z0H玄玄棹0剝g0棹P橚lg棹 gg0棹P 橚lVg棹 gg0棹P 橚lg棹 g剝gg棹剝gD0ZP0lP0g60ZP00gP \gPhgb08P O 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 0Ph O橚 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 0Ph O橚 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"0gb08P O 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"圜#gb08P O 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"gg'B剝叁玄懸更狘堻狖堺pX礫慁xH0桫續給狓堷pX@(圜灑鎊橑hP8 瘕`H佚例` 瘞櫝慅h棹x0佇0橚8h8棼宣耕@(帔鰓苞P8 Hi`  "a "aft 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:58e76cc1%ThisWorkbook: Sheet10;58e76cc19 Sheet1T V? Sheet20<58e76cc2 Sheet2v0V? Sheet30=58e76cc3 Sheet3衋HV? Sheet40>58e76cc3 Sheet48m`V? Sheet50?58e76cc3 Sheet5zxV?H0`xtyPE錄]d幄HY*椙K#愩d'o獥1 N冭發V洋StDO伱錤諊鋱擧P1@皻甉9$讕-l#顱鬉ゆY`r&h[U6 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≡`Worksheet_SelectionChange4` manlingsmax糽` womenlinesmax骮addlinei8`Rows`Insert謗`Delete竫` Application*`ScreenUpdating! ` CommandBars `Enabled酈`Controls蘇` Sheet2` Sheet3` Sheet4` Sheet5`Sheet6`Sheet7`Sheet8`Workbookk` BeforeClose~;`_Defaultj耟 Worksheet窿`ChangeＧ`SelectionChange鉵`_B_var_addlinsvalid檫` _B_var_cco馺_B_var_xmnameid*琡  "%9lI瞼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@#俥@Xt1H2NV?TT 222I2v3U333歇a444R48m 5 55 5 5 釫z __SRP_0__SRP_1PROJECTwmPROJECT$揔*rU@@~ ~~~~~ ~~~ ~ ~ ~ ~ ~ ~ ~f"Q6碡iI懲廖歈漷 儕a 1 a 儕a1 q 儕a1 q 儕a1 q 儕a 1 q 儕a 1 q 1 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 aFLt2 C偠Rヰ艫F蚘S'qF嗗菵虤俽DFWorkbook Workbook_OpenWorkbook_BeforeClose &mFF- O-鉑玤摢 F-*'遲巢A館钑LPkDF 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 USy樤k[ 蟢*N耂[峌SMOP枼b 篘!0;8肒☆M緄2讜#F'獢oK辟,鞄輦D牂4 <綘@+臒2C 癶3E4雜鸤J琟@靋森 爊C檰籠@諵輺私$G｛&vdl4礔0杕N7x i緕束J8輜Lc┇}燌籢岾 xD5VGIH墊諮嘥騚儱巉my/氋 A矁o髐#)6L]K5睾q漸zQ|F礢絸寜&mVrU@@@@~~~r    bbbbbCancel  0  PTargetFThisWorkbookThisWorkbookSheet1Sheet1Sheet2Sheet2Sheet3Sheet3Sheet4Sheet4Sheet5Sheet5ID="{00000000-0000-0000-0000-000000000000}" Document=ThisWorkbook/&H00000000 Document=Sheet1/&H00000000 Document=Sheet2/&H00000000 Document=Sheet3/&H00000000 Document=Sheet4/&H00000000 Document=Sheet5/&H00000000 HelpFile="" Name="VBAProject" HelpContextID="0" VersionCompatible32="393222000" CMG="E3E14F2BF12FF12FF533F533" DPB="898B252A422A42D5BE2B429FDF653430D8727F604E849A6819E908EEC1BA811F4AF5FADE" GC="2F2D837F8F8334843484CB"[Host Extender Info] &H00000001={3832D640-CF90-11CF-8E43-00A0C911005A};VBE;&H00000000[Workspace] ThisWorkbook=44, 58, 716, 502, Z Sheet1=22, 29, 697, 472, Sheet2=44, 58, 719, 501, She    et3=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, 鄥燆鵒h珣+'遲0 X`x 上海索美軟件上海索美軟件上海索美軟件lenovoMicrosoft Excel@E靖D@9q囕@y榒.犙SummaryInformation(,DocumentSummaryInformation8,CompObj h脹諟.摋+,0 PXd lt| slh  學生本科組 研究生組 教工青年組 教工中年組 教工益壯組 工作表 FMicrosoft Excel 2003 工作表Biff8Excel.Sheet.89瞦