Set macro security on medium and then disable them at the prompt when you
open your workbook. Then fix your code.

--
Jim
"JohnP" wrote in message
...
| 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
|
|
|