Black out Background of Userform

[Jeff]

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.

 

[FSt1]

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]

Thanks for your advice,

Now the userform looks a lot better!