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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

populate word from excel: On clickin "Export" button in excel 6
Callling Word fronm Excel 5
export certain cells from excel to word 2
Problem opening a word file from Excel 2
Temporarily stop script 9
Saving a Word document as PDF from en Excel macro 2
writing excel data into word document 1
Word Menus Not Operational After Mailmerge Initiated By Access 1

Back
Top