I am trying to update a range for thirty worksheets using another workbook, the issue I have is before closing normally I will have a question asking users whether to do other stuff to the same worksheet.
Updating is great and the only thing is I have manually answer this question before going to the next workbook.
The question is asked under the event "Workbook_BeforeClose"
I have used
Application.DisplayAlerts = False
Application.ScreenUpdating = False
and I still to have respond to this question.
I have tried SendKeys, which reacts after the question. Or is there a way to know if the calling comes from another workbook to capture the action to identify this case.
Any suggestions?