show COM Add-In dialog

  • Thread starter Thread starter Wm Seales
  • Start date Start date
W

Wm Seales

If a user does not have the Add-Ins... menu item under the Tools menu,
you can still bring up that dialog box from VBA code using either

Application.Dialogs(xlDialogAddinManager).Show

or

Application.Dialogs(321).Show

(The latter uses its ID property.)


Does anyone know if the same is possible with the COM Add-Ins... menu
item?

I've looked in Help's Dialog collection, and also looped through ID
numbers, but without success.

I'm trying to leave the user's toolbars alone and show the COM Add-In
dialog the same as you can the Add-Ins dialog.

Thanks.
 
Try something like the following:

Application.CommandBars.FindControl(id:=3754).Execute


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com
 
To test what you sent, I went to Tools - Customize
and dragged my COM Add-Ins menu item off (to
pretend the user didn't have it either), and then ran your
code.

It resulted in a Run-time error 91.

Any more help? Thanks.
 
Back
Top