Because the button that you are using is not a sheet object, so it doesn't
belong in the sheet's code module. If you had used a button from the control
toolbox, it would have been a sheet event procedure.

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"David" wrote in message
...
Thanks Bob

Why is it that I need to do that?
I am used to working with Access where I put all the code into the form.

"Bob Phillips" wrote:

Put it in a standard code module, not in the worksheet code module.

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my
addy)

"David" wrote in message
...
Hello

I have created a Button on a worksheet called Button1

To test it before going any further, since I am so new, I have entered
this
code in the worksheet

Private Sub Button1_Click()

MsgBox "you clicked here"

End Sub

An error message keeps coming up saying:
"The macro 'Project.xls!Button1_Click' cannot be found.

What am I missing?

David