Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
No CustomizationContext in Excel? | Excel Programming |