Click event to run only once

[gavmer]

HI there,

small problem........i was hoping that once the code ran...that was it.
Prob is, when the file is saved, closed and then open again, the code
can run once more. I will run only once when clicked on un-saved file
but i want to prevent a user from running the code more than once
permanently. Can someone help???

Cheers!!!

 

[Mark]

Gidday,

In a general module


dim mintNumNuts as integer
sub Auto-Open()
mintNumNuts=0
end sub




In the routine to save,

before save option

if mintNumNuts<>0 then
msgbox "This workbook can not be saved",vbcritical
activeworkbook.close false
exit sub
end if

mintNumNuts=1




regards
mark









-Mark