one way. in the workbook with the userform, i used a workbook named weekly.xls:

Sub test2()
UserForm16.Show
End Sub


then in the other workbook

Sub test()
Application.Run "Weekly.xls!test2"
End Sub




--


Gary


wrote in message
...
I am wondering how I can open "userform16" from a spread sheet called
"NPI data entry form" with another spread sheet called "TEAH entry"

Both sheets would be open