Black out Background of Userform

  • Thread starter Thread starter Jeff
  • Start date Start date
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.
 
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
 
Back
Top