Help with Display Setting

[Jenny B.]

Hi All,

I designed an Excel Spreadsheet that not only contains programmed dropdowns
and checkboxes, but other text line fill ins that cannot be resized due to
the current design. Because of the structure, I’m now running into problems
with certain users in regards to their Display setting of 120 DPI vs. the
traditional 96 DPI. When I originally developed this, I set the spreadsheet
to function at 100% Zoom level based on the assumption all users were set to
96 DPI. All of the checkboxes and fill ins are dependant on this setting.
Without this size, the viewing screen is decreased and some of the fields and
checkboxes are compromised because the text scrunches and falls under objects.

Since the view screen becomes too large for those using this Display
setting, I’m looking for a way (without reducing the spreadsheet zoom) to set
a Macro to run on the Open command that defaults their Display DPI to 96 and
sets it back to False after exiting the document? I cannot find any other
postings that relate to this request and I don’t want to go through the pain
of restructuring my whole document just to accommodate this handful of users.

Thanks for your review and any thoughts or help would be greatly appreciate
– Jenny B.

 

[ShaneDevenshire]

Hi,

I suspect that the reason is that screen display settings that apply to
windows are not controlled in Excel. You probably need to call a dll or
something like that. John Walkenback has some examples of that in his
PowerProgramming book. But I don't know if he actually changes the display.

 

[Jenny B.]

Thanks Shane.

It's funny you mention that book for a reference because it's sitting right
next to me and I use it all the time. However, I can't find this specific
example in there, but I'll try his website and see if there is further
information.

Thank you - Jenny B.

 

[AltaEgo]

Ivan Moala has an example that asks the user to change resolution on

http://www.xcelfiles.com/VB_Quick14.html

Take note of his comments immediately under the 'Get Screen Size' heading.

If after reading this you still want to change resolution with code, I found
his code in this thread:

http://www.mrexcel.com/forum/showthread.php?t=3468