The new macro you created has an error in it.

Maybe you could just copy from the original suggestion and try again or copy
what you used and paste into your reply.

Be sure to indicate the line that failed, though.



Rick Tidd wrote:

This worked fine on a sample worksheet, once I tried it on my existing one, I
got the following message:
Compile Error:
Invalid outside procedure.

Is there an easy fix for this?
Thanks
Rick

"Dave Peterson" wrote:

Maybe you could put a button from the Forms toolbar on sheet1 that uses the data
on sheet3 and displays the data|form dialog.

Option Explicit
Sub testme01()
Worksheets("Sheet3").ShowDataForm
End Sub

maybe sufficient.

Rick Tidd wrote:

I want to use a data form in say worksheet1, with the data residing in
worksheet3. Is this doable, or will I need to do the form in VBA?
Thanks
Rick Tidd

--

Dave Peterson


--

Dave Peterson