I have a form that opens various Explorer locations for then opening other spreadsheets. Unfortunately when the user tries to open another spreadsheet it won't as my form remains open.
What I would like to do is for the required spreadsheet to open, and hide my form, which would then re-appear when the required spreadsheet is closed.
I am also hiding the excel application when the form is launched using the following:-
With Application
.WindowState = xlNormal
.Left = 1000
End With
How can this be done?
What I would like to do is for the required spreadsheet to open, and hide my form, which would then re-appear when the required spreadsheet is closed.
I am also hiding the excel application when the form is launched using the following:-
With Application
.WindowState = xlNormal
.Left = 1000
End With
How can this be done?
