how to set the zoom property

L

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
 
B

barnabel

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

2) ActiveWindow.Zoom = 80

Peter Richardson
 
L

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
 
L

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top