Hi Jim,

I just added that code in and closed and saved it despite your wanring. It
now closes as soon as it opens. Is there a way around this. I have tried to
Ctrl Break as it opens.

Please help!!!!

"Jim Rech" wrote:

Not the way to go, in my opinion. Never try to take over the entire screen.

Better to use Application.Visible = False to make Excel disappear. Just be
sure to make it visible again when your form closes.

--
Jim
"JohnP" wrote in message
...
| Hi,
|
| I am designing a system that I want to look like it is not an Excel
| spreadsheet. I would therefore like the UserForms to fill the screen. I
can
| do this manually but if somebody else has a different screen resolution it
| doesn't fit right.
|
| Is there a way of doing this automatically?
| Can you use an if to determine screen resolution?
|
| Thanks in advance for any help you can offer.
| JohnP