Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Comment shows on open then deletes itself
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Comment shows on open then deletes itself
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 -- Regards, Tom Ogilvy "JohnG" wrote in message ... 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Why do (_rels and other sub) shows when trying to open an Excel f | Excel Discussion (Misc queries) | |||
2007 Excel Paste Special Values Deletes Comment | Excel Discussion (Misc queries) | |||
Any way to change the color of the cell corner identifier that shows a comment is present? | Excel Discussion (Misc queries) | |||
XP only shows 4 open windows at bottom | Excel Discussion (Misc queries) | |||
Comment showson open then deletes | Excel Discussion (Misc queries) |