Hi,

When my spreadsheet is opened, a userform automatically pops up. My
question is is it possible to black out the background, so you can't see
excel.

I thought it would look better if there was Blue in the background.

Thanks for your help.

hi
you can hide excel and keep the form visible when you load your form.

application.visible = false

you can load a background picture...

ActiveSheet.SetBackgroundPicture ("C:\My Documents\My Pictures\mypic.jpg")

otherwise the form would appear in the middle of your desktop theme.
then when you close your form..

application.visible = true

this will make excel visible again.

regards
FSt1

"Jeff" wrote:

> Hi,
>
> When my spreadsheet is opened, a userform automatically pops up. My
> question is is it possible to black out the background, so you can't see
> excel.
>
> I thought it would look better if there was Blue in the background.
>
> Thanks for your help.

Thanks for your advice,

Now the userform looks a lot better!

"FSt1" wrote:

> hi
> you can hide excel and keep the form visible when you load your form.
>
> application.visible = false
>
> you can load a background picture...
>
> ActiveSheet.SetBackgroundPicture ("C:\My Documents\My Pictures\mypic.jpg")
>
> otherwise the form would appear in the middle of your desktop theme.
> then when you close your form..
>
> application.visible = true
>
> this will make excel visible again.
>
> regards
> FSt1
>
> "Jeff" wrote:
>
> > Hi,
> >
> > When my spreadsheet is opened, a userform automatically pops up. My
> > question is is it possible to black out the background, so you can't see
> > excel.
> >
> > I thought it would look better if there was Blue in the background.
> >
> > Thanks for your help.