Comment shows on open then deletes itself

[JohnG]

Hello group,

I would like to insert or show a message / comment when a worksheet is
opened for the first time. I then want the comment or message to delete
itself.
Basically, I'm trying to embed a 2 or 3 sentence instruction for users then
have it go away after 15 seconds or after they read it so it doesn't
interfere with future cell data.
Any idea's ?
Thanks.

John

 

[Tom Ogilvy]

If you create a template and the user creates the worksheet by doing
File=>New and selects you template, then you can use the workbook.Open event

Private Sub workbook_Open()
if thisworkbook.path = "" then
msg = "abcd"
msgbox msg
end if
End Sub

This is put in the ThisWorkbook.Module.

You could also place an instruction sheet as the first page, then in the
beforesave event, delete the sheet if it exits.

You can look at Chip Pearson's site on programming the VBE if you actually
want to remove the code:

http://www.cpearson.com/excel/vbe.htm