I am trying to get VBA code to make an Excel CUSTOM VIEW that fills
the screen on a low resolution monitor, also (more or less), fill the
screen on a high or medium resolution monitor.
I a getting pretty desparate now!
Can anybody PLEASE help?

Darryl

Hi Darryl

This will fill any Excel window, regardless of window state and screen
resolution, with Columns A to H:

Sub ZoomUs()
Columns("A:H").Select
ActiveWindow.Zoom = True
ActiveCell.Select
End Sub

--
HTH. Best wishes Harald
Followup to newsgroup only please

"www.ttdown.com" skrev i melding
...
I am trying to get VBA code to make an Excel CUSTOM VIEW that fills
the screen on a low resolution monitor, also (more or less), fill the
screen on a high or medium resolution monitor.
I a getting pretty desparate now!
Can anybody PLEASE help?

Darryl

Dear Harald

Thanks so much for the reply and the neat code that does exactly what I
asked.

UNFORTUNATELY I did not word my request well.

I have a very large spreadsheet that uses code to navigate to any one of
about 200 CUSTOM VIEWS.

Each custom view is the same size as any other but each contains
different data for different people.

Everything worked fine until I loaded a demo onto my boss's computer.

He has a much higher res screen so my precisely defined block of data
ends up as a tiny square on his screen.

I need code that will make a block of cells defined by the "View",
"Custom View", menu command as say "Employee_47_Month_November"
reasonably fill any screen whether 640x480 or 1600x1280. Doesn't have to
fill exactly, as long as all cells in the custom view are visible.

I am begining to wonder if it is possible.?????

Thanks again Harald

Darryl




*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!