98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View ReviewsForum home » Delegate support and help forum » Microsoft Excel Training and help » Excel 2007 Scenario toggling
Excel 2007 Scenario toggling
Resolved · Medium Priority · Version 2007
Simon has attended:
Excel Advanced course
Excel 2007 Scenario toggling
Is it possible to set up an Excel cell, as opposed to a menu dropdown, to toggle on and off Scenarios?
RE: Excel 2007 Scenario toggling
Hi Simon, thanks for your query. Not without writing some code, I'm afraid. You could easily put some data validation on a cell to give you a drop down with the scenario names, but then you'll need to use the Worksheet_Change subroutine to capture the change in scenario name and switch to it. So it's a bit involved!
Hope this helps,
Anthony
RE: Excel 2007 Scenario toggling
Hello Simon,
One more thing you may try without doing any code. Add the Scenario button to your 'Quick Access Toolbar' (QAT).
To do this, click the drop-down on the right hand side of the QAT and select More Commands. Click the drop-down on the top left hand side and choose 'All Commands' then scroll down to Scenario. Double-clicking Scenario will add it to your QAT. Go back to your Home ribbon and if you have scenarios in the sheet you can use the button on your QAT to choose a different scenario.
I hope this resolves your question. If it has, please mark this question as resolved.
If you require further assistance, please reply to this post. Or perhaps you have another Microsoft Office question?
Have a great day.
Regards,
Rodney
Microsoft Office Specialist Trainer
Mon 13 Jun 2011: Automatically marked as resolved.
Training information:
See also:
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Excel tip:Create Charts with One keystrokeCreate a graph with one click |