Userforms fill screen whatever resolution

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

JohnP - 14 Mar 2008 14:31 GMT

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

Reply to this Message

Jim Rech - 14 Mar 2008 15:21 GMT

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.

Signature

Jim

| Hi,
|
[quoted text clipped - 8 lines]
| Thanks in advance for any help you can offer.
| JohnP

Reply to this Message

JohnP - 14 Mar 2008 15:35 GMT

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!!!!

> Not the way to go, in my opinion. Never try to take over the entire screen.
>
[quoted text clipped - 14 lines]
> | Thanks in advance for any help you can offer.
> | JohnP

Reply to this Message

JLGWhiz - 14 Mar 2008 17:00 GMT

Are you sure it closed, or just not visible. Us Alt + F11 to see if the VB
editor will open when the screen goes blank. Another method is to open it as
a second workbook when another is open, then access the VB editor to get to
your code and modify it.

> Hi Jim,
>
[quoted text clipped - 22 lines]
> > | Thanks in advance for any help you can offer.
> > | JohnP

Reply to this Message

Jim Rech - 14 Mar 2008 17:47 GMT

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

Signature

Jim

Reply to this Message