Hi all,

This is my first post so I'd like to start off and say that these forums have been been extremely helpful to search and learn from. Awesome stuff!

Here's my project...I want to create a display of 4 different Excel workbooks. I figured to have one be a "dashboard" that manages the others using command buttons because I can't edit the VBA for the other files. So far I've managed to get all the workbooks to open on_open of the dashboard file and automatically rearrange themselves into a grid.

I want to be able to maximize one of the workbooks to full screen, then return to the quad display. Is there a way to create a sub applying to all open workbooks that activates "On Maximize"?

Any other ideas/methods are welcome as well.

Thanks!
Mike