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

½Ð°Ý¤@¤U¡A¦p¦ó¦b2010excel¤¤¡A¤£±NsheetÁôÂáA¦ý¬O­n¬Ý®É»Ý­n¿é¤J±K½X

½Ð°Ý¤@¤U¡A¦p¦ó¦b2010excel¤¤¡A¤£±NsheetÁôÂáA¦ý¬O­n¬Ý®É»Ý­n¿é¤J±K½X

1¡B§Úªºª©¥»¬°2010¡A¤½¥q¥Îexcel¥²¶·¨î§@Á~¸ê¬ÛÃö¸ê®Æ¡A¦ý¬°¤F½s¿è®É¤è¦¡
       ¤£·Q±N¨ã«O±K©Êªº¦h­ÓsheetÁôÂáA¦ý¥i¯à¦³¨Çsheet¬O»Ý»P¥t¤@¦W¾­û¦@¦P
       ¤S¤£·Q¨C¦¸³£ÁôÂæA¥´¶}¡A¤]©È·|§Ñ°O¦AÁôÂáA¬G¤£ª¾¬O§_¦³sheet¸s²Õªº·§©À¡A
       ©Î·í¥t¤@¦WÂI¨ì¨ã«O±K©Êªºsheet®É¡A¯à¨Æ¥ý´£¥Ü­n¿é¤J±K½X¡A¤~¯àÆ[¬Ý¡C

2¡B­Y¦³¤è¦¡¥i¥Î¡A¬O§_¤]¾A¥Î¦b2010Âà¨ì§ó§Cª©¥»ªºexcel¤W°õ¦æ?¡]¥t¤@¦W¾­ûªºexcelª©¥»¬°xlsª©¡^

·PÁ°ª¤â!

¥»©«³Ì«á¥Ñ mark15jill ©ó 2012-9-28 14:17 ½s¿è

¦^´_ 1# bibi


    1010928.rar (14.96 KB)
  1. Private Sub Workbook_Open()
  2. If Sheets("¤u§@ªí2").Visible = True Then
  3.     Sheets("¤u§@ªí2").Select
  4.     ActiveWindow.SelectedSheets.Visible = False
  5. End If
  6. If Sheets("¤u§@ªí3").Visible = True Then
  7.     Sheets("¤u§@ªí3").Select
  8.     ActiveWindow.SelectedSheets.Visible = False
  9. End If
  10.         Cells.Select
  11.     Selection.EntireColumn.Hidden = True
  12.     Selection.EntireRow.Hidden = True
  13.     UserForm1.Show
  14. End Sub
½Æ»s¥N½X
  1. Private Sub TextBox2_Change()
  2.     If TextBox1.Text <> "" And TextBox2.Text <> "" Then
  3.         ss1 = TextBox1.Text
  4.         ss2 = TextBox2.Text
  5.         If ss1 = "test" And ss2 = "test" Then
  6.             Cells.Select
  7.             Selection.EntireColumn.Hidden = False
  8.             Selection.EntireRow.Hidden = False
  9.         End If
  10.     End If
  11. End Sub
½Æ»s¥N½X

  ¦h°µ¦h·Q¦h¾Ç²ß¡A¤Ö¬Ý¤Ö¿ù¤Ö°g³~

  ¦h°µ=¦h¦h½m²ß¡A¦h¦h½s¼g¡C
  ¦h·Q=·Q·Q¬°¤°»ò¤H®aµ{¦¡­n¨º¼Ë¼g¡A¦pªG´«¦¨¦Û¤v¡A¤S·|«ç¼g¡C
  ¦h¾Ç²ß=¾Ç²ß¤H®aªºµo°Ý¨Ã¸Ñµª¡A¾Ç²ß¤H®aªº¼gªk

  ¤Ö¬Ý=¥u¬Ý¤£°µ¤]ªPµM

TOP

±z¦n¡G

§Ú­nªº¥\¯à¤£¬O±N¤u§@ªí¡uÁôÂáv¡A¦Ó¬O­n·Æ¹«ÂI¨ì¬Y­Ó¤u§@ªí¡]sheet¡^®É¡A¬Y¨Ç¤H¬O»Ý­n¿é¤J±K½X
¤~¯à¬Ý¡C¦b¾ã­Óexcel¬¡­¶Ã¯¸Ì¡A¨C­Ó¤H³£¬Ýªº¨ì¦³´X­Ósheet

¨Ò¦p¾ã­Ó¬¡­¶Ã¯¸Ì¡A¦@¦³1~10­Ósheet¡A§Ú»Ý­n±±ºÞ¬Y­Ósheet¥i¥Î©Î¥iÂI¿ï¬ÝªºÅv­­¤H­û¡C
¦ý¬O§Ú¤£­nÁôÂìY­Ósheet¡C©Ò¥HÀ³¸Ó¬O·í¬Y¤H¥´¶}¡A¥i¥Hª¾¹D¦@¥Î10­Ósheet¦b¡A¦ý·í¥L­nÂI¿ï¨ì
¦³±K½X±±ºÞªºsheet®É¡A·|³Q­n¨D¿é¤J±K½X¡A¤~¯àÂI¶i¥h¡A¯à¤£¯à½s¿è¬O¥Ñ«OÅ@¥\¯à´N¯à¤ä«ù¤F¡C

TOP

        ÀR«ä¦Û¦b : ¤p¨Æ¤£°µ¡B¤j¨ÆÃø¦¨¡C
ªð¦^¦Cªí ¤W¤@¥DÃD