Category Archives for Views

Handling Rollover Clicks Without Using the Worksheet_SelectionChange Event

September 20, 2012
/ Development Excel Tips & Tricks Rollovers Tips Views
/ By Jordan Goldmeier

You probably noticed a “bug” while playing around with my Interactive Periodic Table of Elements in Excel. When you click down into the Table of Elements (or really, anywhere on the sheet), one of the chemical classifications will become “selected,” despite your not having clicked on it directly. This happens because I’ve used the ScrollArea […]

One Size Fits All

October 19, 2011
/ Dashboards VBA Views
/ By Jordan Goldmeier

Anyone who has a made a dashboard in Excel before has probably experienced this problem: a dashboard that fits nicely on your screen but not so nicely on your client’s. Yes, it’s the age old problem of differing monitors, resolutions, font-sizes and other settings that make what looks great on your screen look too small […]