{¤À¨É]¸Ñ°£EXCLE«OÅ@Àx¦s®æªº¥¨¶°µ{¦¡
- ©«¤l
- 1572
- ¥DÃD
- 16
- ºëµØ
- 2
- ¿n¤À
- 1521
- ÂI¦W
- 0
- §@·~¨t²Î
- xp
- ³nÅ骩¥»
- office 2003
- ¾\ŪÅv
- 150
- ©Ê§O
- ¨k
- µù¥U®É¶¡
- 2010-5-1
- ³Ì«áµn¿ý
- 2016-1-13
|
2007¨S¸Õ¹L
¦b2003¡An²¾°£«OÅ@¡A¥un¦A±j¨î°µ¤@¦¸¬Û¦Pªº«OÅ@¡Aì¨Óªº¤u§@ªí«OÅ@´N¨S¤F¡C
¦]¬°³]¤F«OÅ@¤u§@ªí«á¡A¦b¤u¨ã~«OÅ@¤W¥u³Ñ¤U"¨ú®ø«OÅ@¤u§@ªí"¥i¿ï
©Ò¥HÁÙ¬OnVBA¡C¤£À´«ç»ò¼gªºªB¤Í¥i¦b§Oªº¤u§@ªí¿ý»s¤@¹M«OÅ@¤u§@ªíªº¥N½X¡C
¦p¿ý¤U¨Óªº±o¨ìªº¬O¡G- Sub Macro1()
- ActiveSheet.Protect DrawingObjects:=True, Contents:=True, Scenarios:=True _
- , AllowFormattingCells:=True, AllowFormattingColumns:=True, _
- AllowInsertingHyperlinks:=True, AllowFiltering:=True
- End Sub
½Æ»s¥N½X §A¥un¦b©³¤U¥[¤@¦æActiveSheet.Unprotect
Åܦ¨- Sub Macro1()
- ActiveSheet.Protect DrawingObjects:=True, Contents:=True, Scenarios:=True _
- , AllowFormattingCells:=True, AllowFormattingColumns:=True, _
- AllowInsertingHyperlinks:=True, AllowFiltering:=True
- ActiveSheet.Unprotect
- End Sub
½Æ»s¥N½X ¹B¦æ¤@¤U¤u§@ªí«OÅ@´N¨ú®ø¤F¡C |
|
|
|
|
|
|