pop up only once

Microsoft Book: office excel 2003 inside...
July 11, 2010 at 01:34:59
Specs: Windows XP
I have a code to pop up input box after 7 days from the date the user type something in the input box but this input box is re-appearing after every 7 days. How to restrict the pop up input box to appear only once?

See More: pop up only once

July 11, 2010 at 04:32:14

Please post the code you are using.

Without seeing your code it's not possible to advise on what needs to be changed.

Paste your code between <pre> and </pre> tags that you can insert using the 'Pre' icon above the reply box.


Report •

July 12, 2010 at 04:01:30
I have a code in sheet1. I want to run the code in sheet1 only
once if i open this workbook after 15/8/2010. That is if i open
this workbook on 16/8/2010 or any date thereafter then i want
the sheet1 code to run automatically only once but should not
execute thereafter.

Private Sub Workbook_Open()
    If Date > DateSerial(2010, 8, 15) Then
        Call Sheet1.leepak
    End If
End Sub

Report •

July 12, 2010 at 04:20:41
3 possible solutions:

1 - Have the code place or change a value in a cell after 15/8/2010 and have it check that value each time.

Private Sub Workbook_Open()
 If [A1] = 1 then Exit Sub
    If Date > DateSerial(2010, 8, 15) Then
        [A1] = 1
        Call Sheet1.leepak
    End If
 End if
End Sub

2 - Add lines to copy all of the worksheets to a new workbook and then save the workbook under another name. The code will not be saved.

3 - This site shows an example of code that can be used to delete procedures from a workbook.


Make sure you read the introduction before trying any of the examples.

Report •

Related Solutions

July 12, 2010 at 20:38:04
Thanks DerbyDad03 for your suggestion

Report •

Ask Question