Run a macro from PERSONAL to resize any workbook when it opens?

[EdNerd]

People send me workbook files as email attachments, and I always have to adjust the size to fit my screen. I have the macro stored in PERSONAL and can run it from there - not a problem. But is there a way to detect a workbook opening and automatically run the macro every time a workbook opens up?

 

[Micron]

Maybe if you could use Application events. Have never used (requires a class module). It seems that if you could discover the right event it would be a lot of effort compared to the gain, which I see as not having to click on the maximize button on the app window.

 

[offthelip]

The other way is to assign it to a short cut key.