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

°õ¦æ¥¨¶°«ü¥O®É«ö¶s«o¤@ª½¼W¥[(²Ä¤G¦¸µo°Ý)

¦^´_ 8# blueskyneter

§A«ü©wªº¬O¥¨¶°10¸Ì­±ªº¦×®e´N¬O¼W¥[«ö¶s°Ú¡I¬O¤£¬O«ü©w¿ù¤F¡I
  1. Sub ¥¨¶°10()
  2. '
  3. ' ¥¨¶°10 ¥¨¶°
  4. '

  5. '
  6.     Sheets("²î­ûÁ~¸ê½Ð´Ú³æ (§t²Ä¤@¦¸¥Î¶O))").Select
  7.     ActiveSheet.Buttons.Add(579.75, 19.5, 66.75, 42).Select
  8.     ActiveSheet.Buttons.Add(581.25, 64.5, 64.5, 32.25).Select
  9.     ActiveSheet.Buttons.Add(507.75, 29.25, 52.5, 24).Select
  10.     ActiveSheet.Buttons.Add(51, 4.5, 70.5, 16.5).Select
  11.     ActiveSheet.Buttons.Add(509.25, 67.5, 54, 21).Select
  12.     Sheets("²î­ûÁ~¸ê½Ð´Ú³æ (§t²Ä¤@¦¸¥Î¶O))").Copy
  13. End Sub
½Æ»s¥N½X

TOP

¦^´_ 8# blueskyneter


    §âActiveSheet.Buttons.Add³£§R¤F¬Ý¬Ý¬O¤£¬O§A­nªº¡I

TOP

        ÀR«ä¦Û¦b : ¡i¦æµ½­n¤Î®É¡j¦æµ½­n¤Î®É¡A¥\¼w­n«ùÄò¡C¦p¿N¶}¤ô¤@¯ë¡A¥¼¿N¶}¤§«e¤d¸U¤£­n°±º¶¤õ­Ô¡A§_«h­«¨Ó´N¤Ó¶O¨Æ¤F¡C
ªð¦^¦Cªí ¤W¤@¥DÃD