Open worksheet at 70%

  • Thread starter Thread starter Malcolm
  • Start date Start date
M

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
 
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
 
Back
Top