Hi Sheldon,

What is the proper protocol to setting screen resolution within the VBA? Or
is it better just to put up a message requesting the user to change to a
specific screen resolution? Can I even access the screen resolution and
manipulate it from VBA?

The proper protocol is to respond to the user's screen resolution, not impose
your desired resolution on the users.

Regards

Stephen Bullen
Microsoft MVP - Excel
www.oaltd.co.uk