Basically I have a user form that opens up another workbook file. and then hide the user form. Now what I owuld like to do is have a button on the worksheet that will recall the userform and close the workbook.

The user form is frmUsreDataSheet It is in VBAProject(UserformExample.xlsm)

The file or workbook that gets opened is VBAProject(FSO Open Report.xlsx)

I searched the web and there seems to be a lot of conflict about whether it can be done. Some suggestion you create a reference in the FBAProject that houses the userform, and then create a code that references or something like that.

Help Please.

Thanks.

Oh and not sure if I should be using an Activex button or a form control button. but the button will exist on the worksheet.