Hi!
I would like to write code that checks to see how many workbooks
(windows) are open on this application. Can someone help me?
I have code that goes to the next active window and copies a specified
range. If there is no other workbook open or if there is more than 1
other workbook open then I want to display a message box that instructs
the user and stops the macro.
Thanks for your time!


--
Brian Matlack
------------------------------------------------------------------------
Brian Matlack's Profile: http://www.excelforum.com/member.php...fo&userid=3508
View this thread: http://www.excelforum.com/showthread...hreadid=510541