Should be a quick hit...

charlie79 · Apr 24th, 2002, 06:55 AM

Does anyone know how to set the zoom property of a sheet using vba? Thanks in advance...

Ivan F Moala · Apr 24th, 2002, 07:00 AM

Quote:

On 2002-04-24 05:55, charlie79 wrote:
Does anyone know how to set the zoom property of a sheet using vba? Thanks in advance...

ActiveWindow.Zoom = 75

Lookup Zoom in online help for further help

Iain Lewis · Apr 24th, 2002, 07:01 AM

ActiveWindow.Zoom = 75

will give you 75%

charlie79 · Apr 24th, 2002, 07:05 AM

Thanks fellaws...

Burger01 · Jun 2nd, 2002, 08:32 PM

Similar to this, I wish to use "Fit Selection" from the Zoom list. As there are a number of users, all with different screen settings I want to make it easier for Sheet 1 to be seen the same by all.

Apr 24th, 2002, 06:55 AM	#1
charlie79 Board Regular Join Date: Feb 2002 Posts: 97	Does anyone know how to set the zoom property of a sheet using vba? Thanks in advance... __________________ How long a minute is depends on which side of the bathroom door you are standing... Cheers

Apr 24th, 2002, 07:05 AM	#4
charlie79 Board Regular Join Date: Feb 2002 Posts: 97	Thanks fellaws... __________________ How long a minute is depends on which side of the bathroom door you are standing... Cheers

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Apr 24th, 2002, 07:01 AM	#3
Iain Lewis Board Regular Join Date: Apr 2002 Location: Midlands, UK Posts: 217	ActiveWindow.Zoom = 75 will give you 75%

Jun 2nd, 2002, 08:32 PM	#5
Burger01 New Member Join Date: May 2002 Location: Sydney, Australia Posts: 49	Similar to this, I wish to use "Fit Selection" from the Zoom list. As there are a number of users, all with different screen settings I want to make it easier for Sheet 1 to be seen the same by all.