Thursday, March 3, 2011
Unhiding Multiple Worksheets
Most people who use Excel know that you can hide one or more sheets in Excel. Thanks to thesimplemachine.com we now have a short code for unhiding these sheets all at once rather than one at a time. Take a look!
Unhiding Multiple Sheets with VBA
Tuesday, March 1, 2011
Edit Multiple Selections in Excel Drop Down Lists
Microsoft has come up with an amazing array of features in Excel. One such feature is the drop down list which creates the ability for the user to provide feedback that drives other parts of the workbook. Gathering feedback from your audience not only allows your them to change scenarios as they see fit but it prevents you from recreating reports for each scenario.
Contextures Blog » Edit Multiple Selections in Excel Drop Down Lists
As with any feature there are limitations. This is where the beauty of VBA comes into play! In yesterday's blog post from Contextures.com we are shown how you can handle problems with editing drop down lists:
Subscribe to:
Posts (Atom)