Center Spreadsheet on Computer Screen

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!
 
I

isabelle

hi Bob,

a simple way would be:

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