Toggle between workbooks

[Pookiemeister]

I have a userform in a workbook called frmSelectFile with the workbook named Main. The userform opens other workbooks. Once those other workbooks are open, they are considered the Activeworkbook. So I had to Load frmSelectFile so workbook Main now is the Activeworkbook. So my question is how can I get back to the other Workbook that's open so I can close it when I'm done with it? The other workbook is still open in the background but the name of the workbook name could be anything. Is there not something similar to either ActiveWorkbook.deactivate or Workbooks("FileName.xls").deactivate method.
Thank You

 

[RoryA]

You could store either the name of the workbook, or a reference to it in an object variable, when your code opens it.

You should also re-read the forum rules, especially the one about cross-posting, and compy with it please.