Insert this in a regular module

Sub calcNow()
Calculate
End Sub

Insert a Formular-button and link to calcNow macro


"Espen Rostad" skrev:

I'm a real amateur trying to learn. If you have an answer, please make it so
that it's understandable for me to perform solution.. Now heres what I want
to do:

I've made a simple random number function to pick winning numbers in a
lottery.. I would like to be able to perform the function of pressing F9
button, just by klicking a button in the worksheet.. How do I do that?!