You could have an application event looking for when you open an existing file:
http://groups.google.com/groups?thre...apeXSPAM.c om
If you're new to macros, you may want to read David McRitchie's intro at:
http://www.mvps.org/dmcritchie/excel/getstarted.htm
If you want to read more about application events, visit Chip Pearson's site:
http://www.cpearson.com/excel/AppEvent.htm
wuwu wrote:
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
--
Dave Peterson