vba Excel：有什么方法可以在“全屏”类型模式下显示工作表？
声明：本页面是StackOverFlow热门问题的中英对照翻译，遵循CC BY-SA 4.0协议，如果您需要使用它，必须同样遵循CC BY-SA许可，注明原文地址和作者信息，同时你必须将它归于原作者（不是我）：StackOverFlow
原文地址: http://stackoverflow.com/questions/20101203/
Warning: these are provided under cc-by-sa 4.0 license. You are free to use/share it, But you must attribute it to the original authors (not me):
StackOverFlow
Excel: Any way to show a sheet in "full screen" type mode?
提问by user2777137
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?
我有一个工作表，上面有一堆图表，如果有一个 VBA 功能到 Sheets("Graphs") 肯定会很好。激活然后让它进入某种全屏模式，所以我可以更清楚地看到所有图表。这可能吗？
回答by Blackhawk
What you want is:
你想要的是：
Application.DisplayFullScreen = True
and
和
Application.DisplayFullScreen = False
回答by Kubiszyn
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).
添加一个按钮就足够了，或者为什么不链接到功能键作为切换？我已经编写了全屏 Excel 样板代码，您可以使用它来构建一个完整的工作簿，该工作簿可以在全屏模式下切换（您可以添加任意数量的图表）。
You can find it here: http://www.kubiszyn.co.uk/deprecated/software-kioskv6dev.html
你可以在这里找到它：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.
滚动到本文底部的测试版代码，它将最终适用于所有 Excel 版本 9-15，包括 Excel 2013 64 位。
I also have a free AddIn here: http://www.kubiszyn.co.uk/deprecated/software-kiosk4.1.html
我这里也有一个免费的插件：http://www.kubiszyn.co.uk/deprecated/software-kiosk4.1.html
Thanks, Mark
谢谢，马克
