Can the screen resolution be changed within VBA?
 

VBA Experts,

Suppose a user has set the screen resolution to 1024 x 728 pixels,
for example. Can an Excel/VBA program (using API calls) determine
what the resolution is, temporarily change it to 800 x 600 pixels and
then restore it back to whatever it was just before quitting?

-- Dennis Eisen

Can the screen resolution be changed within VBA?
 

It can certainly determine it using the API. Changing it would be very bad
behavior. Have you ever used another windows program that changes the
screen resolution. Windows is a multitasking operating system - other
applications share the screen. Also many people have vision impairments -
they may not share your view of the world.

--
Regards,
Tom Ogilvy

"DennisE" wrote in message
...
VBA Experts,

Suppose a user has set the screen resolution to 1024 x 728 pixels,
for example. Can an Excel/VBA program (using API calls) determine
what the resolution is, temporarily change it to 800 x 600 pixels and
then restore it back to whatever it was just before quitting?

-- Dennis Eisen