View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Jan Karel Pieterse Jan Karel Pieterse is offline
external usenet poster
 
Posts: 535
Default 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


.