ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Comment showson open then deletes (https://www.excelbanter.com/excel-discussion-misc-queries/30150-comment-showson-open-then-deletes.html)

JohnG

Comment showson open then deletes
 
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



Jason Morin

See:

http://tinyurl.com/dqzay

HTH
Jason
Atlanta, GA

"JohnG" wrote:

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




Earl Kiosterud

John,

A macro can do this. If you're willing, we'll write it for you.

--
Earl Kiosterud
mvpearl omitthisword at verizon period net
-------------------------------------------

"JohnG" wrote in message
...
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






All times are GMT +1. The time now is 02:38 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com