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.
|
|