Adding custom property pages to Tools | Options

[michael.herstine]

I'm writing an Excel Add-In, and I'd like to add a property page for my
Add-In to the property sheet displayed by Tools | Options. The Outlook
object model provides interfaces for doing this (the app fires the
OptionsPagesAdd event when the sheet is about to be displayed & gives
the Add-In the chance to add new pages if it wants). However, I can't
find anything similar in the Excel object model.

Am I just missing something, or can this not be done?

 

[Peter T]

No way to add a new 'multi-page' to the Tools Options dialog, or amend in
any other way. Would need to add a menu button on any of the existing
toolbars (or a custom toolbar) or under one of the existing menus, eg Tools.
That could link to run a Userform in your addin that looks like a dialog.

Regards,
Peter T