Puase macro to allow user to open/activate a WB, continue

[TTom]

I can't quite figure out code needed to pause a proceedure, allow user to activate a sheet in another workbook,
may involve opening it first, then let proceedure continue.

Best would be a message prompt:
"Please open/select as active your personal workbook now."
"Select OK once you've done this."

Selecting 'OK' button would allow the proceedure to continue.
Cancel would goto error handler I can write.

MsgBox doesn't allow other task until after OK is selected...
Thanks, TTom

 

[Norie]

Tom

I would need to see the code you have for checking if a workbook is open to tell you how to incorporate my suggested code into it.

There are different 'flavours' of that type of code.

I know at least 2, one uses error handling, the other a loop.

As to allowing the user to select an already open workbook, for that I would suggest creating a userform which lists all currently open workbooks for the user to select.

It could also have an option allowing the user to opt to open a new workbook.

 

[TTom]

As to is open check code, how about this:

Dim strFileName As String, wbEnum As Workbook, blnIsOpen As Boolean
'strFileName = "Path with wb name" (i.e. "C:\UserPath\UserWb.xls") or Variable (i.e. wbPers?)

For Each wbEnum In Excel.Workbooks
If LCase(wbEnum.Path & "\" & wbEnum.Name) = LCase(strFileName) Then blnIsOpen = True: Exit For
Next

If blnIsOpen = False Then 'Workbook isn't open
Workbooks.Open strFileName
End If


On other option using my yes/no query ...
So, there is no easy way to simply pause the macro while user activates their already open workbook, then hit an okay button to continue (my original thought.) IN the end it may KISS solution to request user does not open other WB until they begin macro?