I hate to change the scale every time. It takes me too much time to change to create the best fit.
Does any auto drawing scale macro available?
Check this thread out. Not fully auto but sure quicker than stock.
Also not automatic, but I did create a macro that allows you to select which sheets you want and changes the scale based on the input from 2 textboxes.
Have you tried using this option
Retrieving data ...