Open worksheet at 70%

[Malcolm]

Thanks for the help but I am having trouble in locating
where to place the code.

The active window at the start of the macro is
sheet "Address Details", which then opens a new sheet
which becomes active. Where would I place the code in the
first sheet so that it changes the new sheets zoom size?

Thanks

Malcolm

 

[Dave Peterson]

Add it to your existing macro right after you select that other worksheet.

(does open a new sheet mean add a new sheet? If yes, then add the code right
after you add the worksheet.)

worksheets("sheet99").select
activewindow.zoom = 70
or
worksheets.add
activewindow.zoom = 70