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

[µo°Ý] «OÅ@sheet®É¦p¦ó¦P®É³]©w±K½X¤S³]©w«OÅ@¤è¦¡

[µo°Ý] «OÅ@sheet®É¦p¦ó¦P®É³]©w±K½X¤S³]©w«OÅ@¤è¦¡

¤p§Ì¤S¨Óµo°Ý¤F,ªü¦N¤j¤j¦³¤@¨t¦Cªº«OÅ@¤å³¹,¦ý¤p§Ì¤£¤~,¨S¬Ý¨ì§Ú­n°Ýªº°ÝÃD
«OÅ@³]©w±K½X¡õ
ActiveSheet.Protect Password:="0988"
«OÅ@ªº¤è¦¡¡õ
ActiveSheet.Protect DrawingObjects:=True, CONTENTS:=True, Scenarios:=True

¦p¦ó§â³o¨â­Ó+¦b¤@°_«OÅ@?

¥t¥~¨â­Ó¤p°ÝÃD´¡¦±
1.¬°¦ó­ì©lªº«OÅ@³]©w,¥i¥HÂI¿ï³Q«OÅ@ªºÀx¦s®æ(¦]¬°µLªk°Ê§@)=>ÂI§¹¤§«á©~µM·|"¦Û°Ê"¶}±Ò¬Y¤@­Ó¯S©wªºexcelªí?...©Ò¥H§Ú¥u¦n§ä¤è¦¡Åý¥¦µLªkÂI¿ï³Q«OÅ@ªºÀx¦s®æ
2.¬°¦óexcelªºvba½s¿èÀô¹ÒµLªk¦Û°Ê¸õ¥X¬ÛÃöµ{¦¡½X,¦Ó¤@©w­n«öcrtl+j ¤~·|¸õ¥X¬ÛÃöªºµ{¦¡½X,¬Æ¦Ü¦³¨Ç®×¤Fcrtl+j ÁÙ¸õ¤£¥X¨Ó(¦p¤W²Ä¤G±Æµ{¦¡½X),¥i¬O¥´§¹¤§«á«o·|¦Û¤vÅܬ°¥¿½Tªºµ{¦¡½X?
PKKO

¤ï¶Õ,§Ú¯}¸Ñ¤F,­ì¨Ó¤£¯àÂIÀx¦s®æªº¤è¦¡¬O¡õ
ActiveSheet.EnableSelection = xlUnlockedCells
©Ò¥H§Ú§â¤T¦æ³£©ñ¦b¤@°_´N¦¨¥\ªº³]©w±K½X¤SÁקKÂI¿ïÀx¦s®æ¤F
ActiveSheet.Protect Password:="0988"
ActiveSheet.Protect DrawingObjects:=True, CONTENTS:=True, Scenarios:=True '¦ý³o¦æ¤£ª¾¹D·F¹Àªº= =
ActiveSheet.EnableSelection = xlUnlockedCells
PKKO

TOP

¦^´_ 2# PKKO
   
'¦ý³o¦æ¤£ª¾¹D·F¹Àªº= =
¥i¨ìVBAµøµ¡, »¡©ú¬Ý Protect ¤èªk
  1. Option Explicit
  2. Sub Ex()
  3.     With ActiveSheet
  4.         .Protect Password:="2345", DrawingObjects:=True, Contents:=True, Scenarios:=True
  5.         .EnableSelection = xlNoSelection '¤£¤¹³\¿ï¨ú¥ô¦óÀx¦s®æ
  6.     End With
  7. End Sub
½Æ»s¥N½X
·P®¦ªº¤ß......(¦b³Â»¶®a±Ú°Q½×°Ï.¥Î¤ß¾Ç²ß·|¦³¶i¨Bªº)
¦ý¸ê·½µL­­,«á´©¦³­­,  ¤@¤Ñ1¤¸ªºÃÙ§U,¤H¤H¦³¯à¤O.

TOP

¦^´_ 3# GBKEE


ªO¤j,VBAµøµ¡¬Ý»¡©úªº·N«ä¬O...?

¬O«ü¥­±`½s¿èªºµe­±
¥´¥X«e­±ªºÃöÁä¦r,¥L·|¦Û°Ê¸õ¥X¨Ó"¤@¤p±Æ"»¡©úªº·N«ä¶Ü?

½Ð­ì½Ì§Úªº·M¬N
PKKO

TOP

¥»©«³Ì«á¥Ñ GBKEE ©ó 2014-8-10 14:58 ½s¿è

¦^´_ 4# PKKO
¹ïVBAµ{¦¡½Xªº¨ç¼Æ.ÄÝ©Ê.¤èªk¦³¤£¤F¸Ñªº.
¥i¨ìVBAµøµ¡, ¦³¤@­Ó»¡©ú«ü¥O.
«ö¤U«á ¿é¤J  "Protect "
¥i¬Ý¨ì [Protect ¤èªk] ªº»¡©ú.
·P®¦ªº¤ß......(¦b³Â»¶®a±Ú°Q½×°Ï.¥Î¤ß¾Ç²ß·|¦³¶i¨Bªº)
¦ý¸ê·½µL­­,«á´©¦³­­,  ¤@¤Ñ1¤¸ªºÃÙ§U,¤H¤H¦³¯à¤O.

TOP

¥»©«³Ì«á¥Ñ luhpro ©ó 2014-8-14 01:18 ½s¿è
¦^´_  PKKO
¹ïVBAµ{¦¡½Xªº¨ç¼Æ.ÄÝ©Ê.¤èªk¦³¤£¤F¸Ñªº.
¥i¨ìVBAµøµ¡, ¦³¤@­Ó»¡©ú«ü¥O.
«ö¤U«á ¿é¤J  "ro ...
GBKEE µoªí©ó 2014-8-10 14:49


¸É¥R»¡©ú :

§A¤]¥i¥H§â½s¿è¦ì¸m²¾¨ì Protect ¤å¦r¤¤¶¡, (¤]´N¬O·Æ¹«ÂI¤@¤U Protect ¤å¦r¤¤¥ô¤@¦ì¸m, ¦p : P »P r ¤¤¶¡¡Br »P o ¤¤¶¡¡B...)

¦A«ö¤U F1 «öÁä¤]¥i¬Ý¨ì Protect «ü¥Oªº»¡©ú.

TOP

OK¤F,§Ú¬Ý¤Fª©¤jªº·s¤â±`¨£°ÝÃD,¤w¸g·|¾Þ§@¤F,ÁÂÁÂ!
PKKO

TOP

        ÀR«ä¦Û¦b : ¡i¬°µ½Ävª§¡j¤H¥Í­n¬°µ½Ävª§¡A¤À¬í¥²ª§¡C
ªð¦^¦Cªí ¤W¤@¥DÃD