Center Spreadsheet on Computer Screen

's Computer Specifications

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!

's Computer Specifications

hi Bob,

a simple way would be:

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

--
isabelle

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Center Comments on Center of Screen	Raymond W.	Microsoft Excel Misc	5	15th Sep 2009 04:58 PM
Media Center blank screen & Screen Saver hangs	=?Utf-8?B?UHJhdmVlbg==?=	Windows Vista Hardware	4	11th Oct 2006 01:32 PM
Media Center blank screen & Screen Saver hangs	=?Utf-8?B?UHJhdmVlbg==?=	Windows Vista Hardware	0	4th Oct 2006 06:30 PM
Call Center Tracking Spreadsheet	tskb	Microsoft Excel Discussion	0	20th Sep 2006 09:16 PM
Vista - screen center not in ... center	=?Utf-8?B?Tmljb2xhcw==?=	Windows Vista Hardware	3	27th Jun 2006 06:35 PM