Adding custom property pages to Tools | Options

  • Thread starter michael.herstine
  • Start date
M

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?
 
P

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
 

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

Adding custom property to Range object 1
Adding Custom Property 2
Adding Custom property 9
Howto declare and fill a custom collection of worksheets ? 6
Setting Excel Ready property 2
Custom Document Properties 3
Cell ID property 3
Creating a Custom Worksheet Object 5

Top