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