Balajibenz
Board Regular
- Joined
- Nov 18, 2020
- Messages
- 80
- Office Version
- 2013
- Platform
- Windows
Hi Team,
I have VBA code which works with multiple sheets and have a scenario where user might need to intervene to do some manual changes in one of worksheet in the middle.
what i am looking for is to have a pop-up box where it asks user to do the changes if required and actually allow user to access one of the workbooks that is already opened and once users clicks on ok code should proceed as usual.
I tried to have it as - Msgbox "Please do the manual changes if required"
it is popping up but i am not able to access any of the workbooks that are opened. Can someone help me with this please.
I have VBA code which works with multiple sheets and have a scenario where user might need to intervene to do some manual changes in one of worksheet in the middle.
what i am looking for is to have a pop-up box where it asks user to do the changes if required and actually allow user to access one of the workbooks that is already opened and once users clicks on ok code should proceed as usual.
I tried to have it as - Msgbox "Please do the manual changes if required"
it is popping up but i am not able to access any of the workbooks that are opened. Can someone help me with this please.