I'm having some real trouble with my coursework (it's already overdue ).

AS Level ICT (UK).

Anyway, the problem is, I've to build a spreadsheet for "a company", an invoice. My products workpage has a table with product information, validation rules, and so on, but the problem is that I'm trying to have a button that can be clicked, that uses a macro to open the Form option (Data > Form). I've named the table that I want to use the form with aswell.

Either way, when I record the macro, and click the button I get
Runtime Error '1004':

ShowDataForm method of worksheep class failed.

(It has an option to End, Debug, or Help)


The macro for this is 
Sub ProductFormOptions()
'
' ProductFormOptions Macro
' Macro recorded 28/02/2005 by MCK05100792
'

'
    Application.Goto Reference:="ProductsTable"
    ActiveSheet.ShowDataForm
End Sub
any help please ?