Black out Background of Userform

J

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.
 
F

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
 
Top