| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Adding custom property pages to Tools | Options
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? |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Adding custom property pages to Tools | Options
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 wrote in message ups.com... 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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Tools Options Custom Lists | Excel Discussion (Misc queries) | |||
| Working with options from within Tools Options clears the Clipboar | Excel Programming | |||
| How to diasble the 'Tools - Options - View - Comments' options? | Excel Programming | |||
| Adding a tab to Tools-Options dialog of MS Excel | Excel Programming | |||
| Adding Custom Property | Excel Programming | |||
Hybrid Mode
