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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Center the forms controls on screen on maximize 0
conditional format based on data type 7
Center spreadsheet in middle of window 1
Designing for wide screens 2
WinXP Splash Screen Off-center 1
Form movement 6
How to set up so site is centered no matter what the screen size 1
Weird taskbar entry - how to get rid of it and its file? 1

Top