I have created a Floating Userform called "Due" my question is, can some advise how I set it to open automatically when i open my spreadsheet.

Also is there a way of having the form display without the bar at the top containing name and the red cross?

The Code I am using at the momemnt is below, (The Userform is an Image on a userform)

Private Sub Image1_Activate()
Due.Show
End Sub
and the below on the worksheet I want it to open on.

 Private Sub Worksheet_Activate()
Due.Show vbModeless

End Sub


Shazz