yes you had to save excel as a macro-enabled sheet.
Are you know how to run micros?
It is compulsory to open draft file (which scale you want to change) when you run micros. Are you do the same??
Is it possible to contrain the view on a draft?
I want to keep a point in the same place. When I change the size of my model then change the scale, I have to move the views back into position.