Hi
you have to put this code into the workbook_open event of these files.
AFAIK there's no other option to achieve this

--
Regards
Frank Kabel
Frankfurt, Germany

"wuwu" schrieb im Newsbeitrag
...
Dear all

I have to open a lot of excel files one day, but the view size is not
the
same. How can do that the view size will always change to 80% when I
open
each file.


--
wuwu