Format A1 with no decimal places.
When you want to disable the pop-up, change the value to 1.1.
It won't see a 1 in A1 anymore but your users will.

Todd Huttenstine wrote:
Iv got a code that looks at value A1 of sheet "test.xls"
If it sees a 1 in the cell it displays a mesgbox asking do
you want to update. If it does not see a 1 in cell A1 of
sheet "test", the messagebox never pops up. Is there a
way in code for the user to have an option to never show
that message again?


Thank you

Todd Huttenstine