View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
LetMeDoIt LetMeDoIt is offline
external usenet poster
 
Posts: 25
Default how to set the zoom property

Greetings, my 2 issues seem a simple task but have not been able to
resolve either!

1- I have some VBA code that copies a range in a worksheet to another
workbook/worksheet. In the destination worksheet, once saved and
reopened retains the copy/paste highlight in the range copied. How do
I get rid of this?

2- I would like the zoom setting to be set to 80 when that new
workbook is opened. When that new worksheet is opened, it's set to
100%

I'm using the .PageSetup property which works well for printing only.

Any help is greatly appreciated.
regards, Letmedoit