Yeah sure, put this in your Worksheet Activate event:
response = MsgBox("Do you wish to input data?", vbYesNo + vbQuestion, "Daddy Form!")
If response = vbno Then
Exit Sub
else
userform1.show
end sub
Audiojoe
I need a little break to get away for a holiday. So I can see the sun, cos in the sun they say it's fun, if you get some