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

«OÅ@¤u§@ªí

«OÅ@¤u§@ªí

½Ð°ÝEXCEL¤u§@ªíùØ«OÅ@¤u§@ªí
§Ú¤w±NÀx¦s®æ¸Ìªº«OÅ@    Âê©w¥´£¾
¦ý¬O¦P¼Ë¬Û¦P¤u§@ªí
¤j³¡¤ÀªºÀx¦s®æ¥i¥H³QÂê¦í
¥i¬O¦³¨ÇÀx¦s®æ¬°¤°»òµLªk³QÂê¦í
ÁÙ¬O¥i¥H¥´¦r©O?
³Â·Ð§A­Ì,ÁÂÁÂ

§â¦p¤Uµ{¦¡ ©ñ¸m¥¨¶°¤º¦A°õ¦æ¬Ý¬Ý
Sub «OÅ@A()

  Cells.Select
    Selection.Locked = False
    Selection.FormulaHidden = False
    Selection.SpecialCells(xlCellTypeFormulas, 23).Select
    Selection.Locked = True
    Selection.FormulaHidden = True
    ActiveSheet.Protect DrawingObjects:=True, Contents:=True, Scenarios:=True
'
End Sub

TOP

Àx¦s®æÂê©wÀ³¬O¹w³]­È¡A·|³y¦¨µLÂê©w¬O¤H¬°¾Þ§@³y¦¨
©Î³\§A¦³³]©w¨ì¤¹³\½s¿è½d³ò
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

¦^´_ 1# dodocho
¦pHsieh ª©¥D©Ò¨¥¡A¥ýÀˬd¬Ý¬Ý³o­Ó¦a¤è~

TOP

ÁÂÁª©¥D¤Îsolely,¤×¨äsolelyÁ¿ªº¦n²M·¡
¹q¸£¤£¬O«Ü¦æ,©Ò¥Hª©¥D´£¨ì­«ÂI,¥i¬O¸ê½è¾|¶w,¤£ª¾¦b¦ó¤è
¦Ü©ó¥¨¶°,¤£¼ô¤£´±¸Õ

TOP

§A§ä¨ì«OÅ@¤å¥óªº¦a¤è
¦A¤W¤U¥ª¥k§ä§ä´N¥i¥H¬Ý¨ì¨ì¤F
jeason

TOP

        ÀR«ä¦Û¦b : ¦Û¤v®`¦Û¤v¡A²ö¹L©ó¶ÃµoµÊ®ð¡C
ªð¦^¦Cªí ¤W¤@¥DÃD