Don't you have to hard code a list of computer and user names with screen
resolution? What if one of the users gets a new monitor, or changes the
current monitor's settings? What if the program is used by another user or
on another computer? I'd dig into Jim's approach a little deeper to figure
out how to make it work.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
http://PeltierTech.com
_______


"Minitman" wrote in message
...
Hey Bob,

It turns out that the computer name is the best way to trigger the
size change. I only need to change one machine of my 5.

Your suggestion of using Environ("UserName") modified with
Environ("ComputerName") works very well. Thank you.

-Minitman



On Tue, 5 Dec 2006 12:00:08 -0000, "Bob Phillips"
wrote:

Sorry, I thought that you had that code, you just wanted to know some way
of
testing before invoking it.