Thread: VBA code to make CUSTOM VIEW fill ANY RESOLUTION SCREEN
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Harald Staff Harald Staff is offline
external usenet poster
  
Posts: 1,327
Default VBA code to make CUSTOM VIEW fill ANY RESOLUTION SCREEN
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



Reply With QuoteReply With Quote