Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Switching between Workbooks | Excel Discussion (Misc queries) | |||
Switching between workbooks | Excel Discussion (Misc queries) | |||
Switching Between 2 workbooks using VBA | Excel Programming | |||
switching between workbooks... | Excel Programming | |||
Switching Workbooks in vbscript | Excel Programming |