I did this too. Then tried r-erunning the macro but it didn't work. Goes into
debug mode and highlights this line (ActiveSheet.ShowDataForm).

Matt

"NickHK" wrote:

Matt,
I just recorded a macro of this action and it gave:

ActiveSheet.ShowDataForm

NickHK

"Matthew Balch" ...
The tool in excel under data forms is a very useful tool. But I would
like
this function to be used by other people. So how do I go about creating a
macro that will open up this data form for the selected data range I have
in
mind.

Help appreciated as always.

Regards
Matt