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

[µo°Ý] ¥²¶·°õ¦æ VBA ¥¨¶°

[µo°Ý] ¥²¶·°õ¦æ VBA ¥¨¶°

©ó Excel 2007 ¤º¦³¤èªk±j¦æ­n¨D¨Ï¥ÎªÌ±Ò¥Î/¦P·N±Ò¥Î¸ÓÀɮתº¥¨¶°¤Î°õ¦æ VBA ¤~¯à¶}±Ò¦³ÃöÀÉ®×,
¦p¤£¦P·N«h°¨¤W¦Û¦æÃö³¬ Excel ¶Ü?

¦³¤@­Ó¶¡±µªº¤èªk, §â¤j³¡¥÷¤u§@ªíªºVISIBLE³]¦¨XLVERYHIDDEN, ¦³¥ÎVBAªº¸Ü¤~·|Åã¥Ü.
À´±oµo°Ý,µª®×´N·|¦b¨ä¤¤

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

TOP

¦^´_ 2# kimbal

¦³­Ó·Qªk~~~
§Ú¸Õ¤@¸Õ¥ý~~~
¸Õ§¹¦A¶×³ø~


thx

TOP

¸Õ¸Õ
Private Sub Workbook_BeforeClose(Cancel As Boolean)
Me.IsAddin = True '³]¬°¥[¸ü«¬¤u§@ï
Me.Save
End Sub
Private Sub Workbook_Open()
Me.IsAddin = False '¨ú®ø¥[¸ü
End Sub

¬ÛÃö°Ýµª
http://tw.knowledge.yahoo.com/question/question?qid=1607020309404
My Blog
http://blog.xuite.net/a8350070

TOP

¦^´_ 4# a8350070

§Ú§â³o¨â²Õ¥[¤F¤J¥h, ¦ý¬O¥¦¤´¯à¦b¤£°õ¦æ VBA ªº±¡ªp¤U¶}±Ò§r~~

TOP

¥»©«³Ì«á¥Ñ chin15 ©ó 2011-9-12 22:50 ½s¿è

°Ñ¦Ò³o¸Ì

TOP

¦^´_ 6# chin15


³o­Ó§Ú¸Õ¹L.  2003 only~  ¤@¨ì¤F 2007 - 2010 ´N§¹¥þ¨S¦³¥Î³~¤F~

TOP

¥»©«³Ì«á¥Ñ HUNGCHILIN ©ó 2011-9-13 21:53 ½s¿è

¦^´_ 7# jimmyhk

¨¾¬r³nÅé¥i¯à·|»{¬°¯f¬r¡A½ÐÃö³¬¨¾¬r³nÅé¤~¯à¨Ï¥Î

µµ·L¤æ¼Æ±Æ½Lµ{¦¡.rar (381.01 KB)

TOP

¦^´_ 8# HUNGCHILIN


§Ú¤À¼Æ¥¼°÷¤U¸ü~~~  
­n¿ð¤@ÂI¤~¥i¥H¬Ý¤F~~~

TOP

        ÀR«ä¦Û¦b : ¤H¥Í¤£¤@©w²y²y¬O¦n²y¡A¦ý¬O¦³¾ú½mªº±j¥´ªÌ¡AÀH®É³£¥i¥H´§´Î¡C
ªð¦^¦Cªí ¤W¤@¥DÃD