Center Spreadsheet on Computer Screen

  • Thread starter Thread starter Bob
  • Start date Start date
B

Bob

I have a "General Index" Sheet with commandbuttons on it. I'd like for
it to be centered on any monitor screen. Not printed. Just centered on
screen. More for visual affects than anything else. Thanks in Advance!
 
hi Bob,

a simple way would be:

Sub Test()
Range("A1:E20").Select 'adapt range
ActiveWindow.Zoom = True
End Sub
 
Back
Top