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

½Ð°Ýdelete ¤¤ boolean¦p¦ó³]©w¡A¯àµ¹¨Ò¤l¶Ü¡H

¦^´_ 1# xyzw7
§A¬O­n ¨º¤@­Ó Delete ??
¦bVba »¡©ú Áä¤JDelete »¡©ú §ä§ä¬Ý

TOP

¥»©«³Ì«á¥Ñ GBKEE ©ó 2011-7-30 16:18 ½s¿è

¦^´_ 4# xyzw7
DisplayAlerts ÄÝ©Ê  ¦pªG¥¨¶°¦b°õ¦æ®É Microsoft Excel Åã¥Ü¯S©wªºÄµ§i©M°T®§«h¬° True¡CŪ/¼g Boolean¡C
¬O³o¼Ë¶Ü?
  1. Sub Ex()
  2.     Application.DisplayAlerts = False
  3.     For i = 1 To 2
  4.         Sheets(i).Delete
  5.     Next
  6.     Application.DisplayAlerts =True    '¦^´_  Microsoft Excel Åã¥Ü¯S©wªºÄµ§i©M°T®§
  7. End Sub
½Æ»s¥N½X

TOP

        ÀR«ä¦Û¦b : ®É®É¦n¤ß´N¬O®É®É¦n¤é¡C
ªð¦^¦Cªí ¤W¤@¥DÃD