LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 30
Default A msgbox appears on sheet level once, and only once

I want to put a note by Worksheet_SelectionChange on a worksheet, like
msgbox, to warn the users when they activate that sheet.

But I want that note appears only once, that is, the first time after
the workbook is open and the worksheet is clicked. I do not want to see
that every time the user returns the that worksheet, he is annoyed.

Any ideas?

Thanks in advance.

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
INDIRECT with Sheet Level Defined Name NickH Excel Worksheet Functions 2 June 22nd 11 06:07 PM
unprotect a sheet that appears to be unprotected already TamsinL Excel Worksheet Functions 3 December 9th 06 10:28 AM
If a worksheet name is = to test then a msgbox appears Vick Excel Discussion (Misc queries) 1 December 21st 05 11:17 PM
Unwanted bar appears at the top of the sheet Mark Stephens[_3_] Excel Programming 3 May 1st 05 06:34 AM
Why, when I create workbook-level name does it jump it to Sheet-level ? Charles Jordan Excel Programming 1 November 5th 03 08:43 PM


All times are GMT +1. The time now is 06:58 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"