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
.
|