Romper,

Good questions. No, I don't reset the resolution if they alt-tab to another application. My hope is that they WILL alt-tab, and so see how the new resolution helps them to see their screen better. Now, as to the app crashing, I don't know how to resolve that one, other than firing it up again. I've been working on it for a couple of months now (in between other projects), and I haven't had it crash yet. But there's always a first time.

The app is to review budget information. Since the folks reviewing it aren't comfortable with spreadsheets, we have to present the information in a visual format, by creating graphs. My boss requires that all the data (the whole graph) be visible on one screen, with no scrolling. This means that if I have 500 data items that are charted as stacked bar charts, the chart can't extend beyond the screen. Which means I need a lot of screen to put it in. Which means I have to maximize use of the screen, hence the "display properly" issue.

Another way I could tackle this is by changing the Zoom depending on the count of items in the chart, but then I'd have to also resize the fonts and all elements of the chart. That seems pretty complicated to me, but maybe not to you. I'm still pretty new at this.

Regarding 
"you have designed a workbook knowing that it will not "display properly" for much of your target audience. To me, changing them to fit your design is arrogant."
the workbook WILL display properly for the majority of my target audience. For a very few it will not, and so for those few I go out of my way to make sure that they can still use it. For those, the first option is to reset their display. The second option is to go back to using scroll bars to see all the data. These are their choices. I don't change anything, I give them the option. If making a tool and giving the users the option of how to use it, after explaining how it can be best used, is arrogant, then I accept the adjective.

If you think it's poor design, you're welcome to think that. It's the best I could think of, with my limited knowledge. If you have a better way, I'm wide open to suggestions.

Thanks,
John