Closing a workbook upon opening another
I have been using macros to open, close and activate workbooks for years.
However, recently some users are not able to activate a workbook after Excel has opened a different workbook because it closed the previous workbook. Make sense so far. Is there something in Excel that I can switch to get the program to leave workbooks open when opening another? Thanks, Dave |
Closing a workbook upon opening another
Dave
The "closed" workbook could still be open but not showing on the taskbar. Can you see it under Window? Maybe you just have to go to ToolsOptionsView and check "Windows in Taskbar" Gord Dibben MS Excel MVP On Wed, 3 Jan 2007 09:39:01 -0800, Dave wrote: I have been using macros to open, close and activate workbooks for years. However, recently some users are not able to activate a workbook after Excel has opened a different workbook because it closed the previous workbook. Make sense so far. Is there something in Excel that I can switch to get the program to leave workbooks open when opening another? Thanks, Dave |
Closing a workbook upon opening another
I cannot see it under Window and my "Windows in Taskbar" is checked. Just
not sure what is causing the file to close. When opening files outside of Visual Basic I can open mutiple files no problem. When our I.T. department re-installs Office, it fixes the problem. So, I may have to continue to go this route. "Gord Dibben" wrote: Dave The "closed" workbook could still be open but not showing on the taskbar. Can you see it under Window? Maybe you just have to go to ToolsOptionsView and check "Windows in Taskbar" Gord Dibben MS Excel MVP On Wed, 3 Jan 2007 09:39:01 -0800, Dave wrote: I have been using macros to open, close and activate workbooks for years. However, recently some users are not able to activate a workbook after Excel has opened a different workbook because it closed the previous workbook. Make sense so far. Is there something in Excel that I can switch to get the program to leave workbooks open when opening another? Thanks, Dave |
Closing a workbook upon opening another
Thanks for the update.
Looks like you have narrowed it down to a VBA problem. Gord On Wed, 3 Jan 2007 10:15:01 -0800, Dave wrote: I cannot see it under Window and my "Windows in Taskbar" is checked. Just not sure what is causing the file to close. When opening files outside of Visual Basic I can open mutiple files no problem. When our I.T. department re-installs Office, it fixes the problem. So, I may have to continue to go this route. "Gord Dibben" wrote: Dave The "closed" workbook could still be open but not showing on the taskbar. Can you see it under Window? Maybe you just have to go to ToolsOptionsView and check "Windows in Taskbar" Gord Dibben MS Excel MVP On Wed, 3 Jan 2007 09:39:01 -0800, Dave wrote: I have been using macros to open, close and activate workbooks for years. However, recently some users are not able to activate a workbook after Excel has opened a different workbook because it closed the previous workbook. Make sense so far. Is there something in Excel that I can switch to get the program to leave workbooks open when opening another? Thanks, Dave |
All times are GMT +1. The time now is 04:14 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com