Thanh l?nh c?a Excel add-in khng hi?n th? ho?c g? b? t? ?ng vo nm 2013 Excel khi b?n t?i ho?c d? b? cc add-ins

D?ch tiu ? D?ch tiu ?
ID c?a bi: 2761240 - Xem s?n ph?m m bi ny p d?ng vo.
Bung t?t c? | Thu g?n t?t c?

? Trang ny

Tri?u ch?ng

Khi b?n s? d?ng cc add-in trong Microsoft Excel 2013, b?n g?p v?n ? sau.

V?n ? 1

Khi b?n t?i m?t Excel add-in (.xlam) ho?c m?t Excel 97-2003 add-in (.xla), cc thanh l?nh c?a cc add-in ?c khng hi?n th? t? ?ng. Thay vo , b?n ph?i ng t?t c? cc b?ng tnh v sau kh?i ?ng Excel ? hi?n th? thanh l?nh.

V?n ? 2

Khi b?n l?y m?t Excel add-in (.xlam) ho?c m?t Excel 97-2003 add-in (.xla) ho?c ng m?t b?ng tnh Excel v? m cho php (.xlsm) c l?nh qun Bar, qun Bar ch? huy cc add-in ho?c b?ng tnh v? m cho php khng ?c g? b? t? t?t c? cc sch bi t?p m?.

Nguyn nhn

Nh?ng v?n ? ny x?y ra b?i v? cc m?i duy nh?t ti li?u giao di?n (SDI) vo nm 2013 Excel. Khi b?n s? d?ng m?t ?i t?ng CommandBar di s?n ? t?o m?c tr?nh n, cc m?c tr?nh n s? ?c thm vo tab Add-Ins c?a ribbon. Trong nm 2013 Excel, m?i b?ng tnh c bng ring c?a m?nh. V? v?y, khi b?n t?i ho?c d? b? cc add-in sau khi cc ribbon b?ng tnh ?c t?o ra, cc ribbon khng ?c C?p Nh?t.

M?u m? sau y t?o ra m?c tr?nh n b?ng cch s? d?ng cc ?i t?ng CommandBar:
Application.CommandBars("Worksheet Menu Bar").Controls.Add(Type:=msoControlPopup)

Cch gi?i quy?t khc

? lm vi?c xung quanh v?n ? 1, ng t?t c? m? s? lm vi?c, v sau kh?i ?ng Excel.

? lm vi?c xung quanh v?n ? 2, s? d?ng m?t trong nh?ng phng php sau y:
  • Thay th? l?nh qun bar v?i m?t m?c Ribbon (XML) trong cc add-in ho?c b?ng tnh v? m cho php. ? bi?t thm thng tin v? Ribbon (XML), i ?n web site c?a Microsoft sau y:
    Bng XML
  • Trong cc Workbook_BeforeClose Cc s? ki?n c?a cc add-in ho?c b?ng tnh v? m cho php, v?ng l?p thng qua m? c?a s?, v lo?i b? cc thanh l?nh. Sau y l m?t m?u m?:
    For Each wnd In Application.Windows
            wnd.Activate
            Application.CommandBars("<ToolbarName>").Delete
    Next wnd
    
    Lu ? Trong quy t?c ny, vi?c gi? ch?ToolbarName> ?i di?n cho tn thanh l?nh.

Thu?c tnh

ID c?a bi: 2761240 - L?n xem xt sau cng: 22 Thang Mi Mt 2012 - Xem xt l?i: 3.0
p d?ng
  • Microsoft Excel 2013
T? kha:
kbaddin kbprb kbexpertiseadvanced kbsurveynew kbmt KB2761240 KbMtvi
My d?ch
QUAN TRONG: Bi vi?t ny ?c d?ch b?ng ph?n m?m d?ch my c?a Microsoft ch? khng ph?i do con ng?i d?ch. Microsoft cung c?p cc bi vi?t do con ng?i d?ch v c? cc bi vi?t do my d?ch ? b?n c th? truy c?p vo t?t c? cc bi vi?t trong C s? Ki?n th?c c?a chng ti b?ng ngn ng? c?a b?n. Tuy nhin, bi vi?t do my d?ch khng ph?i lc no c?ng hon h?o. Lo?i bi vi?t ny c th? ch?a cc sai st v? t? v?ng, c php ho?c ng? php, gi?ng nh m?t ng?i n?c ngoi c th? m?c sai st khi ni ngn ng? c?a b?n. Microsoft khng ch?u trch nhi?m v? b?t k? s? thi?u chnh xc, sai st ho?c thi?t h?i no do vi?c d?ch sai n?i dung ho?c do ho?t ?ng s? d?ng c?a khch hng gy ra. Microsoft c?ng th?ng xuyn c?p nh?t ph?n m?m d?ch my ny.
Nh?p chu?t vo y ? xem b?n ti?ng Anh c?a bi vi?t ny: 2761240

Cung cp Phan hi

 

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