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

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

On Aug 8, 5:22*pm, "Gary Keramidas" <GKeramidasATmsn.com wrote:
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- Hide quoted text -

- Show quoted text -

If I run the macro to run the userform from the same spread sheet it
works but if I run the macro that runs the macro I get a subscript out
of range error

not sure what's going on without seeing it.

--


Gary


wrote in message
...
On Aug 8, 5:22 pm, "Gary Keramidas" <GKeramidasATmsn.com wrote:
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- Hide quoted text -

- Show quoted text -

If I run the macro to run the userform from the same spread sheet it
works but if I run the macro that runs the macro I get a subscript out
of range error

when i use this:
Private Sub Workbook_BeforeClose(Cancel As Boolean)
Application.Run "NPI data entry form.xls!Macro1"
End Sub

it says it cannot find the macro

when i use this
Private Sub Workbook_BeforeClose(Cancel As Boolean)
Application.Run "'NPI data entry form.xls'!Macro1"
End Sub

i get subcript out of range

I got it working
Thanks