Can the screen resolution be changed within VBA?

[DennisE]

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

 

[Tom Ogilvy]

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.