Re: Automatic Screen Fit

Tech-Archive recommends: Fix windows errors by optimizing your registry

in article 1151244934.943013.173050@xxxxxxxxxxxxxxxxxxxxxxxxxxxx, Ken
Johnson at KenCJohnson@xxxxxxxxx wrote on 6/25/06 10:15 AM:


Is there a way I can also de-select those cells, and
instead select my first input cell (say, "C2")?

Hi Rick,

Silly me, I didn't notice that!

Private Sub Worksheet_Activate()
Me.Range("A1:H4").Select
Application.ActiveWindow.Zoom = True
Me.Range("C2").Select
End Sub


will fix that up.

Ken Johnson

Each answer brings up another idea/question! Your first response suggested
adding code for the Workbook so the first screen appears properly upon
opening. What if someone saves the file while on another *** (so that
that *** appears upon re-opening the file)? Can I add a line of code to
the This Workbook Code Module that will automatically make the intended
Work*** open?

In other words, if I want sheet1 to appear on opening, and the user saves
such that sheet3 appears, how can I correct that?

Thanks again, I appreciate all your help.
-Rick

.

Quantcast