I can write a code to close all the books except the one open withou
changing the focus. As far as the error goes, I would have to see th
error when it's occuring to see where in the code it's breaking. I
you want, you can send me the book and I will look at the code for an
errors. if so, send me a private msg on here and I'll give you m
email address to send it to

--
dok11
-----------------------------------------------------------------------
dok112's Profile: http://www.excelforum.com/member.php...fo&userid=1058
View this thread: http://www.excelforum.com/showthread.php?threadid=50901