how to set the zoom property

[LetMeDoIt]

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

 

[Guest]

1) Select a single cell on the sheet. After the paste do a cells(1,1).select

2) ActiveWindow.Zoom = 80

Peter Richardson

 

[LetMeDoIt]

1) Select a single cell on the sheet. After the paste do a cells(1,1).select

2) ActiveWindow.Zoom= 80

Peter Richardson









- Show quoted text -

Thank you for your quick response. It's greatly appreciated. #1 is
now OK, but the #2 problem persists. I'm doing a ActiveWindow.Zoom=
80 statement right after the window (or sheet) is selected, but still
nothing. Display zoom is still at 100%. If any ideas, pls let me
know. Many thanks,
regards, letmedoit

 

[LetMeDoIt]

Thank you for your quick response. It's greatly appreciated. #1 is
now OK, but the #2 problem persists. I'm doing a ActiveWindow.Zoom=
80 statement right after the window (or sheet) is selected, but still
nothing. Displayzoomis still at 100%. If any ideas, pls let me
know. Many thanks,
regards, letmedoit- Hide quoted text -

- Show quoted text -

I was able to resolve the issue. Many thanks.