Hi all
Scenario as follows;
I have a userform that is set up which will be run from any workbook (the workbook will always have a unique name). However the userform is set up to open another workbook in the background when a command button is clicked.
My problem is that I want to extract some data from the unique workbook when the command button is initialised.
Where can I put the code so that the original workbook becomes the active workbook, bearing in mind that when the userform is selected, the workbook in the background becomes the active workbook.
Hope this makes some sense.
Thanks in advance
Scenario as follows;
I have a userform that is set up which will be run from any workbook (the workbook will always have a unique name). However the userform is set up to open another workbook in the background when a command button is clicked.
My problem is that I want to extract some data from the unique workbook when the command button is initialised.
Where can I put the code so that the original workbook becomes the active workbook, bearing in mind that when the userform is selected, the workbook in the background becomes the active workbook.
Hope this makes some sense.
Thanks in advance