TTom
Well-known Member
- Joined
- Jan 19, 2005
- Messages
- 518
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
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