Could you please help me identify the ID for the Solver add-in button and the group ID for the Analysis group in the Data tab in the ribbon in Excel 2010? Even though Solver comes with Excel, I didn't see those ID's in the list of "Office Fluent User Interface Control Identifiers" available from Microsoft (perhaps because Solver is developed by a third-party).
My reason for looking for the ID is that I would like to specify an onAction callback using XML/ RibbonX in the customUI.xml file (google "Customizing the 2007 Office Fluent Ribbon for Developers (Part 1 of 3)" and/or "Change the Ribbon in Excel 2007 or Excel 2010" for more info on what I generally hope to do).
My goal is to allow my own VBA code to run when a user selects the Solver button in a protected worksheet (normally Solver can't be run in a protected worksheet). My own VBA code would un-protect the worksheet, run Solver, then re-protect the worksheet. I know disabling/enabling protection like this isn't fool-proof, but for my needs, it's better than nothing.
Beyond using some existing list that shows what the IDs are, is there a tool / method that can be used to show ribbon IDs?
Thank you for your help!
My reason for looking for the ID is that I would like to specify an onAction callback using XML/ RibbonX in the customUI.xml file (google "Customizing the 2007 Office Fluent Ribbon for Developers (Part 1 of 3)" and/or "Change the Ribbon in Excel 2007 or Excel 2010" for more info on what I generally hope to do).
My goal is to allow my own VBA code to run when a user selects the Solver button in a protected worksheet (normally Solver can't be run in a protected worksheet). My own VBA code would un-protect the worksheet, run Solver, then re-protect the worksheet. I know disabling/enabling protection like this isn't fool-proof, but for my needs, it's better than nothing.
Beyond using some existing list that shows what the IDs are, is there a tool / method that can be used to show ribbon IDs?
Thank you for your help!