Zooming of Excel

R

Rich Cooper

I am creating a report using excel and i want to write/find a module that
makes my report open up on anyones machine using excel 2000 look the same.
I want it to adjust the zoom according to the users screen setting? Is this
possible? I am not sure how to do it. If anyone knows could they help i am
looking for a way for when you open up my excel program it will look the
same on everyones machine no matter what the screen settings are at. Excel
will adjust for them automatically making my report look the way it does on
my machine. Is this possible?
 
J

JWolf

Try something like this:

Private Sub Worksheet_Activate()
Range("a1:h1").Select
ActiveWindow.Zoom = True
If ActiveWindow.Zoom > 130 Then
ActiveWindow.Zoom = 130
End If
End Sub

Right-click on the sheet tab, select view code and paste this. Adjust
the range and maximum size (130% in this example to whaterver you choose)
 

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

Similar Threads

Prevent Extreme Zoom Out. Mouse Wheel Event? 2
Screen size and Window size 5
stop excel automated zooming 2
Zoom problem with shapes in Excel 2007 2
zoom problem ?? 6
Already Zoomed Out as Far as Possible 0
HELP! Command buttons moving to edge of Worksheet when unhiding rowsand-or columns 10
adjust zoom according to sheet 3

Top