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

how to set the zoom property
 

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

2) ActiveWindow.Zoom = 80

Peter Richardson

"LetMeDoIt" wrote:

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

how to set the zoom property
 

On Sep 9, 11:48 pm, barnabel
wrote:
1) Select a single cell on the sheet. After the paste do a cells(1,1).select

2) ActiveWindow.Zoom= 80

Peter Richardson



"LetMeDoIt" wrote:
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 thezoomsetting to besetto 80 when that new
workbook is opened. When that new worksheet is opened, it'ssetto
100%

I'm using the .PageSetuppropertywhich works well for printing only.

Any help is greatly appreciated.
regards, Letmedoit- Hide quoted text -

- 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

how to set the zoom property
 

On Sep 10, 9:26 pm, LetMeDoIt wrote:
On Sep 9, 11:48 pm, barnabel
wrote:





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

2) ActiveWindow.Zoom= 80

Peter Richardson

"LetMeDoIt" wrote:
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 thezoomsetting to besetto 80 when that new
workbook is opened. When that new worksheet is opened, it'ssetto
100%

I'm using the .PageSetuppropertywhich works well for printing only.

Any help is greatly appreciated.
regards, Letmedoit- Hide quoted text -

- 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. 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.