Macro: Run time error: Object required

[Michelle Hillard]

Hi guys,

I have attached a macro to a command button.

The code for the macro is:

Sub PlaceYinColumnD()
ActiveCell.Text = "y"
End Sub

It is in its own module
When I click on the button, I get
Run time error, object required.

Any ideas would be greatly appreciated.

--


---------------------------------------------------------------------
"Are you still wasting your time with spam?...
There is a solution!"

Protected by GIANT Company's Spam Inspector
The most powerful anti-spam software available.
http://mail.spaminspector.com

 

[Harald Staff]

One possible problem might be that the button har its "takefocusonclick"
property set to True.