userform and macro

[red95]

i have a circulation user form saved in a file and i have a main menu user form with a button to run circulation user form but when i run it it put the data on my main menu sheet that is open but i need it on the circulation sheet that is not open any ideal??

 

[mikerickson]

It sounds like one of the userforms is using unqualified cell references.
Replace syntax like
Range("A1").Value = "x" with
Workbooks("Workbook1.xls").Worksheets("KeySheet").Range("A1").Value = "x"

 

[red95]

i am in the menu.xlsm when i use this

Private Sub CommandButton1_Click()

Application.Run "circulation.xlsm!circulation"

End Sub

but it put the data in the menu.xlsm but it needs to go in the circulation.xlsm

 

[mikerickson]

The code in the userform is not pointing to circulation.xlsm.
My guess is that it uses unqualified range references, i.e. pointing to the ActiveWorkbook.
The code in the userform has to be changed for it to work properly.

 

[red95]

thanks i got it