View Single Post
  #1   Report Post  
GarryH
 
Posts: n/a
Default How can I get a macro in Excel to set the Zoom to "Selection"?

I have created a Workbook_Open macro that selects a range and zoom, but the
macro only records the setting on the PC that it was created on, i.e 100%.
Can this 100 be changed within the macro to make use of the Selection option
in zoom so that it will work on other PC's with different screen
sizes/resolutions?