Macro: Run time error: Object required

  • Thread starter Thread starter Michelle Hillard
  • Start date Start date
M

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
 
One possible problem might be that the button har its "takefocusonclick"
property set to True.
 
Back
Top