CODEWITHSUNDEEP
excelvba
user2777137
user2777137

Reputation: 191

Excel: Any way to show a sheet in "full screen" type mode?

I have a worksheet with a bunch of graphs on it and it'd sure be nice to have a VBA function of some sort to Sheets("Graphs").Activate and then have it go into some sort of full-screen mode so I can see all the graphs more clearly. Is this possible?

Upvotes: 1

Views: 6005

Answers (2)

Kubiszyn
Kubiszyn

Reputation: 1

Adding a Button should suffice or why not link to a Function key as a Toggle? I have written Full Screen Excel boilerplate Code which you can use to build a complete Workbook that can be toggled in & out of Full Screen Mode (you could add in as many Charts as you like).

You can find it here: http://www.kubiszyn.co.uk/deprecated/software-kioskv6dev.html

Scroll to the bottom of this article for beta Code that will eventaully work for all Excel Versions 9-15 including Excel 2013 64bit.

I also have a free AddIn here: http://www.kubiszyn.co.uk/deprecated/software-kiosk4.1.html

Thanks, Mark

Upvotes: 0

Blackhawk
Blackhawk

Reputation: 6140

What you want is:

Application.DisplayFullScreen = True

and

Application.DisplayFullScreen = False

Upvotes: 5

Related Questions