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

[µo°Ý] ²¤Æ­«½Æªº for each ... in

[µo°Ý] ²¤Æ­«½Æªº for each ... in

½Ð°Ý­n«ç¼Ë²¤Æ¤U­±³o¬qµ{¦¡¶Ü????
  1. For Each Abar In Application.CommandBars
  2.         If Not Abar.BuiltIn Then Abar.Delete
  3.     Next

  4.     For Each Bbar In Application.CommandBars
  5.         If Not Bbar.BuiltIn Then Bbar.Delete
  6.     Next

  7.     For Each Cbar In Application.CommandBars
  8.         If Not Cbar.BuiltIn Then Cbar.Delete
  9.     Next

  10.     For Each Dbar In Application.CommandBars
  11.         If Not Dbar.BuiltIn Then Dbar.Delete
  12.     Next

  13.     For Each Ebar In Application.CommandBars
  14.         If Not Ebar.BuiltIn Then Ebar.Delete
  15.     Next

  16.     For Each Fbar In Application.CommandBars
  17.         If Not Fbar.BuiltIn Then Fbar.Delete
  18.     Next
½Æ»s¥N½X

¦^´_ 1# s13030029
¥Î°}¦Cªº¤è¦¡¡A¤w¸Ñ¨M~~~
    bbar = Array(bar1, bar2, bar3, bar4, bar5, bar6)
    For Each bbar In Application.CommandBars
        If Not bbar.BuiltIn Then bbar.Delete
    Next

TOP

        ÀR«ä¦Û¦b : ¯à·F¤£·F¡A¤£¦p­W·F¹ê·F¡C
ªð¦^¦Cªí ¤W¤@¥DÃD