open user Form in workbook1 from workbook2

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?