No CustomizationContext in Excel?
 

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(...)T hen new buttons and
menuitems was saved on the document, not in normal.dot. How to do it in
Excel?ThanksBentDenmark

No CustomizationContext in Excel?
 

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

-----Original Message-----
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


.