Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old April 20th 05, 06:10 PM
Brett
 
Posts: n/a
Default Fit Selection Setting Doesn't Hold

I have created an invoice that I want to email to a company. I have the
invoice worksheet formatted so that the entire invoice is visable and fills
the entire width of my screen at 100% Zoom Magnification. It occured to me
that if the company has a screen resolution different from mine, the entire
invoice will not fill the screen. I discovered this when I changed my own
screen resolution.
I thought the solution to this problem would be to simply highlight the area
I wanted to fill the screen and then set the View Zoom Magnification to Fit
Selection. After I did that, I then changed my screen resolution to a lower
setting. Unfortunately, the Fit Selection Setting didn't hold. It reverted
back to 100% Zoom Magnification and my invoice was now partially off screen.
I'm thinking the solution may need to be a macro that runs when the document
is openned that will select the area of the invoice and then change the Zoom
Magnification to Fit Selection, but does anyone knows of simpler way?

  #2   Report Post  
Old April 20th 05, 10:22 PM
Dave Peterson
 
Posts: n/a
Default

I'd use that macro approach, too.

Option Explicit
Sub auto_open()

With Worksheets("sheet1")
Application.Goto .Range("a1:m1"), scroll:=True
End With
ActiveWindow.Zoom = True

End Sub


In fact, I make a very skinny column just to the right of my range. I find that
it makes things fit a bit nicer if I include that skinny (unused) column, too.



Brett wrote:

I have created an invoice that I want to email to a company. I have the
invoice worksheet formatted so that the entire invoice is visable and fills
the entire width of my screen at 100% Zoom Magnification. It occured to me
that if the company has a screen resolution different from mine, the entire
invoice will not fill the screen. I discovered this when I changed my own
screen resolution.
I thought the solution to this problem would be to simply highlight the area
I wanted to fill the screen and then set the View Zoom Magnification to Fit
Selection. After I did that, I then changed my screen resolution to a lower
setting. Unfortunately, the Fit Selection Setting didn't hold. It reverted
back to 100% Zoom Magnification and my invoice was now partially off screen.
I'm thinking the solution may need to be a macro that runs when the document
is openned that will select the area of the invoice and then change the Zoom
Magnification to Fit Selection, but does anyone knows of simpler way?


--

Dave Peterson


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
List box - setting default selection Brian Excel Discussion (Misc queries) 2 January 26th 05 08:47 PM
SELECTION() Thrava Excel Discussion (Misc queries) 2 January 2nd 05 01:33 AM
Setting macro security level to "low" permanently? Arobind Excel Discussion (Misc queries) 1 December 22nd 04 01:41 AM
Setting default pivot table field setting to "sum" Mr. Moose Excel Discussion (Misc queries) 2 December 21st 04 04:43 PM
limit cell list selection based on the selection of another list lorraine Excel Worksheet Functions 2 December 14th 04 08:17 PM


All times are GMT +1. The time now is 05:18 PM.

Powered by vBulletin® Copyright ©2000 - 2021, Jelsoft Enterprises Ltd.
Copyright 2004-2021 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017