ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Switching workbooks before close (https://www.excelbanter.com/excel-programming/386449-switching-workbooks-before-close.html)

Carl Hartness[_2_]

Switching workbooks before close
 
When closing one of several open files, I am trying to pick which file
is active after the close, by activating it from code. I've tried
Workbooks(index%).Activate in both Workbook_BeforeClose and
Workbook_Deactivate which follows it. Since ThisWorkbook is a class
module, I also tried to putting Workbooks(index%).Activate in a sub in
a regular module. Application.ScreenUpdating is True. What is
blocking workbook activate?



All times are GMT +1. The time now is 07:36 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com