Please Note: This article is written for users of the following Microsoft Excel versions: 2007, 2010, and 2013. 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, and 2013. You can find a version of this tip for the older menu interface of Excel here: Specifying Your Target Monitor.
Create Custom Apps with VBA! Discover how to extend the capabilities of Office 2013 (Word, Excel, PowerPoint, Outlook, and Access) with VBA programming, using it for writing macros, automating Office applications, and creating custom applications. Check out Mastering VBA for Office 2013 today!
If you use Excel's Web Query tools to grab data from a website, you may run into some problems if the site isn't available ...
Discover MoreHyperlinks in a worksheet can be helpful or essential, depending on the nature of your data. If you create a link to a ...
Discover MoreIf you have a list of hyperlinked e-mail addresses in a worksheet, you may want to extract the addresses from those ...
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 © 2017 Sharon Parq Associates, Inc.
Please Note:
This article is written for users of the following Microsoft Excel versions: 2007, 2010, and 2013. 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