ªð¦^¦Cªí ¤W¤@¥DÃD µo©«

«O护VBA

«O护VBA

¦p¦ó«O护VBA ¤£µ¹¨ä¥L¤H¬Ý?
50 ¦r¸`¥H¤º
¤£¤ä«ù¦Û©w¸q Discuz! ¥N½X

¦^´_ 1# basarasy


    ³Ì²³æªº¤èªk´N¬O§Q¥Î±K½XÂê©w±M®×¡A¾Þ§@¤è¦¡¦p¤U
123.gif

TOP

¦^´_ 2# victorl

ÁÂÁ¤j¤jªº¸Ñµª

¦ý¦p¦ó¥i¥H¥[±j«O护VBA©M ¦p¦óLOCK  EXCEL¥u¯à¦b¥u©w¦a¤è¤~¥i¥H¥Î?
50 ¦r¸`¥H¤º
¤£¤ä«ù¦Û©w¸q Discuz! ¥N½X

TOP

¦^´_  victorl

ÁÂÁ¤j¤jªº¸Ñµª

¦ý¦p¦ó¥i¥H¥[±j«O护VBA©M ¦p¦óLOCK  EXCEL¥u¯à¦b¥u©w¦a¤è¤~¥i¥H ...
basarasy µoªí©ó 2010-7-16 06:29



¦³Ãö¥[±j«OÅ@: ¨ä¹êvictorl¥S¤¶²Ðªº¤èªk, ¤w¸g¬Û·í¦w¥þªº¤F, excel¤º«Ø¤]¥u¦³³o­Ó¤èªk.
¦pªGÁÙ¬O¤£«H¥ô³o­Ó¤èªk, ¦Û¤v°Ê¤â¼gªº¸Ü, ³o¸Ì¦³¤@­Ó«D±`§xÃøªº¤èªk:
1.¥Îtxt§â¥N½X¦s°_, §ä¤èªk¥[±K
http://www.blog.methodsinexcel.c ... ncryption-workbook/  (¨S¦³´ú¸Õ³o, ¥u¦bgoogle search)
2.¹B¦ævba®É,§â¥N½X¥Ñtxt¨ú¥X¤Î¸Ñ½X, µM«á¥Î Microsoft Visual Basic for Application Extensibility ¾É¤J, ³Ì«á¹B¦æ¾É¤Jªº¥N½X
http://support.microsoft.com/kb/ ... 2533&sid=global
³o¸Ì¥u¯à¤¶²Ð¤@¤U, ¸Ô²Ó°µ¤]­n¤@¨â¤Ñ

¦³Ãö"LOCK  EXCEL¥u¯à¦b¥u©w¦a¤è¤~¥i¥H",  §Aªº·N«ä¬O¥u¦³xls¦b¬Y­Ó¦ì¸m¤~¯à¹B¦ævba?
§A¥i¥H¥Îthisworkbook.path ¨Ó§ä·í«e¤u§@諸¦ì¸m,µM«á§PÂ_¬O§_Ä~Äò¹B¦æ
¤S©ÎªÌ§äip address/ mac address
http://ithelp.ithome.com.tw/question/10045072?tag=ithome.nq

¨ä¹ê³Ì²³æªº¤èªk.... §Ú·Q¬O¥Îexcelªº¥»¨­¦³ªº¥\¯à, ¶}±Ò®É¥Î±K½X¤~¥i¥H¶}±ÒexcelÀÉ...
À´±oµo°Ý,µª®×´N·|¦b¨ä¤¤

¤µ¤éの¤@¬íは  ©ú¤éにない
http://kimbalko-chi.blogspot.com
http://kimbalko.blogspot.com

TOP

¦^´_ 4# kimbal
ÁÂÁÂkimbal¤j¤j
50 ¦r¸`¥H¤º
¤£¤ä«ù¦Û©w¸q Discuz! ¥N½X

TOP

        ÀR«ä¦Û¦b : ¬Ý§O¤H¤£¶¶²´¡A¬O¦Û¤v­×¾i¤£°÷¡C
ªð¦^¦Cªí ¤W¤@¥DÃD