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

¥¨¶°»P«OÅ@¤u§@ªí

¥¨¶°»P«OÅ@¤u§@ªí

§Ú³]©w¤F«OÅ@¤u§@ªí,¦Ó¥B«OÅ@¤u§@ªíÁÙ³]¥ß±K½X
§Ú³]¤F¤@­Ó¥¨¶°,¦WºÙ¥s<¨ú®ø¤u§@ªí>
¥i¬O¥¨¶°°õ¦æ®É,¦o¥s§Ú¿é¤J  «OÅ@¤u§@ªíªº±K½X
¥i¬O¿ý»s¥¨¶°®É§Ú¤w¸g¿é¤J±K½X¤F
¬°¤°»ò°õ¦æ¥¨¶°®ÉÁÙ­n¦A¿é¤J±K½X©O?
¦³¨S¦³¤èªk°õ¦æ®É¤£¥Î¿é¤J±K½Xªº¤èªk??
³Â·Ð¦U¦ì

¿ý»s®É¨Ã¥¼§â±K½X¼g¤J¥¨¶°
§A­n¦Û¤v¥[¤W
§ä¨ìActiveSheet.Unprotect ³o¦æ¡A¥[¤W±K½X
¦pActiveSheet.Unprotect "123"

TOP

ÁÂÁÂ,¥i¬O¦pªG¼g¶i¥h±K½X,·|¤£·|³]ªº¤u§@ªí«OÅ@±K½X´N³Q§O¤Hª¾¹D¤F
¥¨¶°¥i¥[Âê¶Ü?

TOP

¦^´_ 3# dodocho
   

TOP

ª©¥D¹ïVBA¦n¼F®`³á
¥i¬O§Ú¦b¤u¨ã¸Ì,§ä¤£¨ìVBAÄÝ©Ê.......

TOP

¦^´_ 5# dodocho


    VBEªº¤u¨ã¡A¤£¬O¬¡­¶Ã¯ªº¤u¨ã
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

¼H§ä¨ì¤F,ÁÂÁÂ,­ì¨Ó¤£À´±oÁ٫ܦh,¥[ªo

TOP

¹ï¤£°_,ÁÙ­n³Â·Ð§A­Ì
§Ú¼g¤J¤F±K½X,¥i¬O³Ì«áÁÙ­n±N¥¦¥[±K½X
½Ð°Ý§Ú­n¥[¦b­þÃä??
    ActiveSheet.Unprotect "0000"
    Range("D12:BM15").Select
    Selection.ClearContents
    ActiveSheet.Protect DrawingObjects:=True, Contents:=True, Scenarios:=True

TOP

¦^´_ 8# dodocho
       ActiveSheet.Protect Password:="0000", DrawingObjects:=True, Contents:=True, Scenarios:=True
¦P¤W ActiveSheet.Protect "0000",True, True, True

TOP

«Ü²M·¡«Ü©ú¥Õ«Ü·PÁ§A

TOP

        ÀR«ä¦Û¦b : ¨ü¤HÂI¤ô¤§®¦¡A¶··í´é¬u¥H³ø¡C
ªð¦^¦Cªí ¤W¤@¥DÃD