No CustomizationContext in Excel?

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
 
J

Jan Karel Pieterse

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
 

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

Making a macro only work on certain files 2
populate word from excel: On clickin "Export" button in excel 6
export certain cells from excel to word 2
Callling Word fronm Excel 5
Saving a Word document as PDF from en Excel macro 2
Problem opening a word file from Excel 2
Letter merge using backend data 2
Saving a word document but maintaining the document with its bookm 1

Top