??? CommandBar ???????? ?? ??? ID ?? ???? ?? ??? ????? ??????

???? ?????? ???? ??????
???? ID: 162814 - ?? ???????? ?? ?????? ??? ?? ?? ???? ???? ???? ??.
??? ?? ??????? ???? | ??? ?? ??????? ????

?? ????? ??

??????

CommandBar ???????? ?? ??? ??? ID ???????? ?????????? ???? ?????, ??????? ???? ?????, ??????, ???? ???? ?? ????? ????? ?? ??? ?? ????? ???? ?? ????? ???? ??? ?? ?? ??? ???? ????? ?? ??? ???????? ?????? ID ?????? ???? ??? ?? ???? ??? ????????? ?????? ?????? ?? ??? Visual Basic ID ??????? Commandbar ???????? ?? ??? ???? ??? ???

???? ???????

???????? ??????? ?? ???, Microsoft ?????? ??? ??? ???? ????? ?? ??? ????? ???? ?????? ????? ????::
159466XL97: ?????????? ???? ????? ???????? ?? ??? ID ???????? ????

Microsoft ???????????? ?????? ???? ???????? ?? ??? ??? ???? ??, ???? ??? ??? ?? ?????? ?? ?????????? ??? ??? ?????? ???? ?? ????.. ?????? ???????? ?????? ?? ???? ????? ???????? ?? ??? ???????? ????? ??? ?? ???? ?? ????? ???? ???.. ?? ??? ????? ?? ?? ?? ????? ?? ?? ??? ???????????? ???? ?? ?? ??????? ?? ?????? ??? ????? ????? ???????????? ?? ????? ?? ???? ???? ?? ??? ???? ?? ??? ??.. Microsoft ?????? ???????? ?? ????? ????????? ?? ???????????? ?? ?????? ??? ?????? ?? ???? ???, ??, ?? ?? ???????? ?? ???? ??????? ?????????? ?? ?????? ???? ?? ??? ???????? ??????????????? ?? ?????? ?? ???????????? ????? ?? ??? ??????? ???? ??????..

???? ???? ????? ?? ' ????

????? ?????? ?????? ?? ??? ID ???? ??????????? ?? ?????????? - ????? ???? ????? ???:
   Sub File_Id

      Dim x as Object
      set x = CommandBars("Chart Menu Bar").Controls("Tools")
      MsgBox x.Caption & Chr(13) & x.Id

   End Sub
				

???? ???? ?? ' ???? ????

????? ?????? ?????? ?? ???? ?????? ' ???? ?? ??? ID ???? ???????????????? ?????????? ???? ????? ????:
   Sub FileExit_Id()

      Dim x as Object
      set x = CommandBars("Worksheet Menu Bar").Controls("File") _
      .Controls("Exit")
      MsgBox x.Caption & Chr(13) & x.Id

   End Sub
				

??? ?????? ?? ?? ??????? ???? ?? ' ????

????? ?????? ?????? Calculated ?? ??? ID ???? ?? ?? ???? ?? ?????????PivotTable ?? ?????? ??????? ???? ?????:
   Sub SubMenu_Command_Id()

      Dim x as Object
      set x = CommandBars("PivotTable Context Menu").Controls("Formulas") _
      .Controls("Calculated Item...")
      MsgBox x.Caption & Chr(13) & x.Id

   End Sub
				
????? ?????? ?????? PivotTable ??????? ???? ????? ?? ' ????? ' ?????? ?? ??? ?????? ?? ??? ID ???? ??:
   Sub GetAll_Submenu_Ids()

      Dim ctrl as Object
      For Each ctrl in CommandBars("PivotTable Context Menu") _
      .Controls("Formulas").Controls
         MsgBox ctrl.Caption & Chr(13) & ctrl.Id
      Next ctrl

   End Sub
				

??????

????????? ??????? ?? ???? ??? ???? ??????? ?? ??? ????????, Visual Basic Editor ??? ????, ????? ????Office ???????????:???? ???????? ????????? ????,???, ?? ???? ??? "?????? ???? ????? ??? ??." ?? ????? ?? ??? ????? ????

???:??? ????? ???? ??? ??, ?? ????? ????Office ????????? ????? ????? ?? ??? ??? ??? Microsoft Visual Basic ?????? ???? ???????? ?? ??????? ???? ??, ????? ???? ?? Microsoft ???????? ??? ?????:
120802Office: ???? ??????/??????? ?? ??? ??? ??? Office ????????? ?? ???

???

???? ID: 162814 - ????? ???????: 20 ??????? 2011 - ??????: 5.0
???? ???? ???? ??:
  • Microsoft Excel 2002 Standard Edition
  • Microsoft Excel 2000 Standard Edition
  • Microsoft Excel 97 Standard Edition
??????: 
kbhowto kbprogramming kbmt KB162814 KbMthi
???? ?????? ????????
??????????: ?? ???? ?? ???? ??????? ?? ????? ?? Microsoft ????-?????? ?????????? ?????? ?????? ???? ??? ??. Microsoft ???? ??? ????-???????? ?? ????-???????? ????? ?????? ?? ???? ???????? ???? ?? ???? ????? ????? ??? ?? ??? ?????? ?? ???? ???? ???? ??? ????? ??. ???????, ????-???????? ???? ????? ???? ???? ???? ???. ?????, ????????, ?????-???? ?? ??????? ?? ???????? ?? ???? ???, ???? ?? ??? ?????? ???? ???? ??? ????? ??? ?? ???? ??. Microsoft ??????? ??? ???? ?? ?????? ?? ??????????, ????????? ?? ??? ?????? ?? ???? ????? ?? ???? ???????? ?? ??? ???? ????? ?? ??? ????????? ???? ??. Microsoft ????-?????? ?????????? ?? ????? ?????? ?? ?? ??? ??.
?????????? ?? ??????? ????????? ??????? ??:162814

??????????? ???

 

Contact us for more help

Contact us for more help
Connect with Answer Desk for expert help.
Get more support from smallbusiness.support.microsoft.com