No CustomizationContext in Excel?

  • Thread starter Thread starter Bent Kjeldsen
  • Start date Start date
B

Bent Kjeldsen

Hi.Can't find CustomizationContext in Excel like ind Word. In Word I could
do the following:Dim objWord As Word.Application
objWord = CType(objWordInstance, Word.Application)
objWord.CustomizationContext = objWord.ActiveDocument
objWord.CommandBars("Standard").Controls.Add(...)Then new buttons and
menuitems was saved on the document, not in normal.dot. How to do it in
Excel?ThanksBentDenmark
 
Hi,

Excel behaves differently in this area than Word.

Any change to the commandbar system is *always*
application-wide. If you want certain commands to be only
available when a particular workbook is active (or open),
you need to use Workbook events to enable/disable the
menuitems.

Regards,

Jan Karel Pieterse
Excel TA/MVP
 
Back
Top