How to run a macro on a datasheet

[Beamer2010]

I know I have done this on the 2003 version. I need to be able to run a macro on my data sheet. I would like for the user to be able to click on a cell and open a form that will show more info, but I can't seem to find out how to insert a macro on the data sheet.

 

[welshgasman]

It is just a control, so the macro is assigned to an event in design mode. The Click event for example.
This applies whether it is in Single Form mode or Datasheet mode.

 

[mole999]

workbook needs to be xlsm or xlsb (i've answered this as excel, because it does seem to be an excel question (though I'm easily wrong))

 

[HotRhodium]

Are you wanting to insert a button or have this run when a cell is clicked?