Automatic Macros

M

mbe4966

I have a spreadsheet template and would like for a small instructio
window to open when the template is opened. I would like for th
instruction window to close as soon as the user clicks on th
worksheet.

I am not a programmer so I hope this is not too complex.

Thx
 
E

E_R

Maybe a balloon window would work for you...

Private Sub Workbook_Open()

With Assistant.NewBalloon
..BalloonType = msoBalloonTypeBullets
..Icon = msoIconTip
..Button = msoButtonSetOK
..Heading = "Tips for Saving Information."
..Labels(1).Text = "Save your work often."
..Labels(2).Text = "Install a surge protector."
..Labels(3).Text = "Exit your application properly."
..Show
End With

End Sub
 
Top