Hi Amanda,
All I want is a room somewhere,
Far away from the cold night air ...
Guess I'm getting old too. I love the idea you've got but what I'd like is for windows to behave more like panes in some circumstances, so that as one shrunk the other(s) grew - not sure about the proportional bit though.
I don't see any real reason why a macro couldn't do as you suggest in an Office application (others might be more difficult) - I might have a play with it.