open user Form in workbook1 from workbook2

Ok I put the code into new module in thworkbook where the fomr exist, then I put the application.run code into the command button in the workbook where the button exist.

Now I am getting the following error run time error 1004 Method "Run" of object"_Application" failed.

Originally Posted by Izandol

Then you must create routine in normal module like:

Public Sub ShowDataSheetForm()
frmUsrDataSheet.Show
End Sub

then you may use:

Application.Run "UserformExample.xlsm!ShowDataSheetForm"

Ok I just noticed in the error it has the following path ..c:\users\ddempsey\Documents\userformexample.xlsm.. This is not the correct path, why is it looking here for the form.

The form is in the following path. C:\Users\ddempsey\Desktop\notes

should i move it to the path noted in the error?