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

[µo°Ý] ¦p¦ó¤£¨Ï¥Î«O护¤u§@ªí¡A¤S¯à对ªí进¦æ编辑«O护

[µo°Ý] ¦p¦ó¤£¨Ï¥Î«O护¤u§@ªí¡A¤S¯à对ªí进¦æ编辑«O护

¤@个¤u§@ªí¦³两个¤H¨Ï¥Î¡A»Ý­n对¦U¤H编辑³¡¤À¥[±K¡C¦]为两¤H³£»Ý­n对单¤¸®æ编辑¡A¤ñ¦p¦X¦}单¤¸®æ¡A¤£¯à¨Ï¥Î«O护¤u§@ªí¤è¦¡¥[±K¡C
¦³没¦³¨ä¥L¤èªk¥i¥Î¡H¤ñ¦p¥ÎVB¥N码¡C¡C¡C

¬°¦ó¤£¯à¨Ï¥Î«O护¤u§@ªí¥\¯à¡A¦³¯S§O­ì¦]¶Ü?

TOP

¦]为设¸m«O护¤u§@ªí¡A´N¤£¯à¨Ï¥Î¦X¦}单¤¸®æ¡Aªí®æ编辑时»Ý­n¥Î这个¥\¯à¡C°£¤F这个¤èªk¡A´¿经试过¨Ï¥Î两个ªí¡A¤@¤H负责¤@个ªí¡A³Ì¦Z¦X¦}显¥Ü¦¨¤@个ªí¡A¨C个ªí¥Î¥[±K¡C没¦³¦¨¥\¡C

TOP

¦]为设¸m«O护¤u§@ªí¡A´N¤£¯à¨Ï¥Î¦X¦}单¤¸®æ¡Aªí®æ编辑时»Ý­n¥Î ...
kiva29 µoªí©ó 2010-7-13 09:09


    ¤£¯à¯dªÅ¶¡¹w¥ý¦X¨Ö?
À´±oµo°Ý,µª®×´N·|¦b¨ä¤¤

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

TOP

设¸m«O护¤u§@ªí´N¤£¯à¦X¦}单¤¸®æ¡A¤S¤£¥i¯à预¥ý¦X¦}¡A编辑ªÌ实际输¤J资®Æ¤~¥Î¨ì¡C

TOP

简单点说¡A这¬O°µ审§åªº¥\¯à¡C­ì来¥Î单ÉóªºexcelªA务¾¹´N¥i¥H实现¡AÊI络¦@¨É¦Z´N¤£¦æ¤F¡C单独¥Îexcel¡A这个¤£ª¾¹D¦³没¦³¥i¯à¡H

TOP

¦^´_ 6# kiva29
§A³o¼Ëªº»¡©úÁÙ¬O¤ÓÅ¢²Î
¦]¬°¤èªk¤Ó¦h¤Ó¦h¤£ª¾¹D­n¥Î¨º¤@­ÓÀ°§A ¦Ó¥B¤£¤@©w²Å¦X§Aªº»Ý¨D
¨SªþÀÉ®×...

¥ý¥Î³o­Ó§a VBA­n¶}
­ì²z¬O§Q¥Î USERNAME ¦p¹Ï
¨Ó§PÂ_¨Ï¥ÎªÌ¡C¡C¡CÃþ¦ü¨Ï¥ÎªÌ´N¬O±K½XªºÆ[©À
¥Ø«e¬OVBA³]©w "HUNGCHILIN" ¤~¯à½s¿è¨Ï¥ÎSHEET1
§A¦pªG­n³o¨â¤H³£¥i¥H¥Î
´N¦b¥L­Ìªº¹q¸£±N³o¦W¦r³]©w¬°"HUNGCHILIN"

·íµM¤£­n³]¬°³o¦W¦r ½Ð§ïVBA



    AA.rar (6.25 KB)

TOP

¨ãÅé·N«ä¡Auser1¥u¦³Åv­­½s¿è¦P¤@­ÓªíA~D¦C¡Auesr2¥u¦³Åv­­½s¿è¦P¤@­ÓªíE~H¦C¡C¥»¨Ó¨Ï¥Î«OÅ@¤u§@ªí³]¸m´N¥i¥H¹ê²{¡A¦ý»s¿ö®É»Ý­n¥Î¨ì¦X¨Ö³æ¤¸®æ¡A°ÝÃD¥X¨Ó¤F¡C²{¦b·Q§ä§ä¨ä¥Lªº¤èªk¡C

TOP

¥»©«³Ì«á¥Ñ Hsieh ©ó 2010-7-14 22:33 ½s¿è

§A¤£¯à¤U¸ü

¥Î³oµ{¦¡§a ©ñ¦bthisworkbook¤º
¨Ï¥Î¤èªk:¦b¤W­z¹Ï¤ù¨Ï¥Î¦WºÙ¤º¿é¤J
user1©Îuser2«á¶}±Ò´N¥i¥H¤F


Private Sub Workbook_Open()

Sheet1.Protect Password:=1
   
    If Application.UserName = "USER1" Then
   
    Sheet1.ScrollArea = "A:D"
    Sheet1.Unprotect Password:=1
   
    Else
   
        If Application.UserName = "USER2" Then
        
        Sheet1.ScrollArea = "E:H"
        Sheet1.Unprotect Password:=1
        
        Else
        Sheet1.ScrollArea = "A1"
        Sheet1.Protect Password:=1
        
        End If
   
    End If
   
End Sub
AA.rar (6.85 KB)

TOP

¥»©«³Ì«á¥Ñ kiva29 ©ó 2010-7-15 16:56 ½s¿è

³o­Óµ{§Ç¦³¥Î¡A¨ü±Ð¡AÁÂÁ°Õ

TOP

        ÀR«ä¦Û¦b : ¤@­Ó¤H¤£©È¿ù¡A´N©È¤£§ï¹L¡A§ï¹L¨Ã¤£Ãø¡C
ªð¦^¦Cªí ¤W¤@¥DÃD