Please Note: This article is written for users of the following Microsoft Excel versions: 2007, 2010, 2013, 2016, 2019, and Excel in Office 365. If you are using an earlier version (Excel 2003 or earlier), this tip may not work for you. For a version of this tip written specifically for earlier versions of Excel, click here: Specifying Your Target Monitor.
If you are developing Web pages in Excel, it is a good idea to have in mind who the user is. The user, obviously, is the person who will view your Web page. However, there are certain assumptions that must be made about the user, and those assumptions will affect how you put your Web page together.
One of the prime considerations is what resolution of monitor the user will be using. This affects the presentation of graphics and text on their page. For instance, a graphic that shows up nicely centered on your screen at a high resolution may not give the desired impact if the user is working at a lower resolution.
You can instruct Excel to make certain assumptions about the user's monitor resolution as you are developing Web pages. You set the target resolution by following these steps:
Figure 1. The Pictures tab of the Web Options dialog box.
ExcelTips is your source for cost-effective Microsoft Excel training. This tip (6222) applies to Microsoft Excel 2007, 2010, 2013, 2016, 2019, and Excel in Office 365. You can find a version of this tip for the older menu interface of Excel here: Specifying Your Target Monitor.
Program Successfully in Excel! John Walkenbach's name is synonymous with excellence in deciphering complex technical topics. With this comprehensive guide, "Mr. Spreadsheet" shows how to maximize your Excel experience using professional spreadsheet application development tips from his own personal bookshelf. Check out Excel 2013 Power Programming with VBA today!
When you insert into a cell a hyperlink that references a file on your system, the text displayed by default matches the ...
Discover MoreWouldn't it be great if Excel could automatically e-mail you when a due date is reached? It can, if you are using Outlook ...
Discover MoreWhen you add a hyperlink to a worksheet, it consists of a minimum of two parts: display text and URL address. If you have ...
Discover MoreFREE SERVICE: Get tips like this every week in ExcelTips, a free productivity newsletter. Enter your address and click "Subscribe."
2015-01-19 08:57:53
You can read a screen's resolution, kinda, by placing this in the Workbook_Open event (with global variables):
ActiveWindow.Zoom = 100
Application.DisplayFullScreen
height = ActiveWindow.VisibleRange.height
width = ActiveWindow.VisibleRange.width
Then place your elements accordingly.
Got a version of Excel that uses the ribbon interface (Excel 2007 or later)? This site is for you! If you use an earlier version of Excel, visit our ExcelTips site focusing on the menu interface.
FREE SERVICE: Get tips like this every week in ExcelTips, a free productivity newsletter. Enter your address and click "Subscribe."
Copyright © 2020 Sharon Parq Associates, Inc.
Please Note:
This article is written for users of the following Microsoft Excel versions: 2007, 2010, 2013, 2016, 2019, and Excel in Office 365. If you are using an earlier version (Excel 2003 or earlier), this tip may not work for you. For a version of this tip written specifically for earlier versions of Excel, click here: 
Comments