I am currenty tweaking this code to make it so that the excel applications I build for our sales team adjust based on the large variation in monitor sizes. If you want to use this code on your own project please follow these instructions. Once you have accessed your excel document enter the VBA environment.
Accessing VBA in Excel Press Alt+F11 from within an opened Excel document Either 'Insert a Module' by clicking the insert button or 'Right-Click' on a worksheet and select 'View Code' Copy the code below. Paste the code into the new module or worksheet code area.
Adjusting the VBA code If you want to adjust the zoom of all worksheets then comment out (by adding a ' before the line) or remove the following lines If activews = cmws Then maxWidth = GetSystemMetrics(0) * 0.5 Else End If If you want to target a specific worksheet then change the name of the value between Sheets("enter worksheet name here").Name in the variable cmws