Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I want to see the msgbox only once when I first activate the sheet. I
do not want to be bothered again and again. But the msgbox keeps popping up every time I go to the sheet.. What is wrong with the following two codes? Option Explicit Dim ABC Sub Workbook_Open() ABC = False End Sub Sub Worksheet_Activate() If IsNull(ABC) Then ABC = False End If If ABC = False Then MsgBox "Please pay attention to this formula." ABC = True End If End Sub Thanks in advance H.Z. |
Thread Tools | Search this Thread |
Display Modes | |
|
|