Excel Data Form

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 here:

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

--
Jim Rech
Excel MVP
"Don Lloyd" <[email protected]> wrote in message
news:[email protected]...
| 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" <[email protected]> wrote in message
news:%[email protected]...
> This problem is discussed here:
>
> http://support.microsoft.com/default...b;en-us;213835
>
> --
> Jim Rech
> Excel MVP
> "Don Lloyd" <[email protected]> wrote in message
> news:[email protected]...
> | 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.
> |
> |
>
>