Hi,
Can someone explain the following.
A cell is selected in a standard list with Headers.

The macro below was recorded when clicking Data / Form and the Form
appeared.

Sub Test
ActiveSheet.ShowDataForm
End Sub

If I run (or step thro') the macro error 1004 appears
"ShowDataForm method of worksheet.class failed"

This happened when an user was using Excel2000 and again with me in Excel 97
(also Xl2003)

Don.

This problem is discussed he

http://support.microsoft.com/default...b;en-us;213835

--
Jim Rech
Excel MVP
"Don Lloyd" wrote in message
...
| Hi,
| Can someone explain the following.
| A cell is selected in a standard list with Headers.
|
| The macro below was recorded when clicking Data / Form and the Form
| appeared.
|
| Sub Test
| ActiveSheet.ShowDataForm
| End Sub
|
| If I run (or step thro') the macro error 1004 appears
| "ShowDataForm method of worksheet.class failed"
|
| This happened when an user was using Excel2000 and again with me in Excel
97
| (also Xl2003)
|
| Don.
|
|

Thank You Jim.

"Jim Rech" wrote in message
...
This problem is discussed he

http://support.microsoft.com/default...b;en-us;213835

--
Jim Rech
Excel MVP
"Don Lloyd" wrote in message
...
| Hi,
| Can someone explain the following.
| A cell is selected in a standard list with Headers.
|
| The macro below was recorded when clicking Data / Form and the Form
| appeared.
|
| Sub Test
| ActiveSheet.ShowDataForm
| End Sub
|
| If I run (or step thro') the macro error 1004 appears
| "ShowDataForm method of worksheet.class failed"
|
| This happened when an user was using Excel2000 and again with me in
Excel
97
| (also Xl2003)
|
| Don.
|
|