Cutomize the zoom to 80%
 

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

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

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

for each ws in worksheets
ws.select
activewindow.zoom=80
next

Further, you can set a print range for each sheet and use
activewindow.zoom=true.

--
Don Guillett
SalesAid Software

"wuwu" wrote in message
...
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

Sub setzoom()
Sheets.Select
ActiveWindow.Zoom = 90
Sheet1.Select
End Sub

--
Don Guillett
SalesAid Software

"Don Guillett" wrote in message
...
for each ws in worksheets
ws.select
activewindow.zoom=80
next

Further, you can set a print range for each sheet and use
activewindow.zoom=true.

--
Don Guillett
SalesAid Software

"wuwu" wrote in message
...
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