I'm having a few problems when one workbook is open, then another
containing macros is opened (while the first is still open). The
macro's cease up in this situation and they do funny things.
So, I am wondering if there is a test procedure to check if there is a
workbook open, and if so, then I can send a
Sub TestWrkBks()
* If...'OtherWorkbooksAreOpen?'...Then
MsgBox "Please close all other workbooks and try again"
ActiveWorkbook.Close
End if
End Sub
Any assistance would be much appreciated.
Kartune85
--
kartune85
------------------------------------------------------------------------
kartune85's Profile:
http://www.excelforum.com/member.php...o&userid=35586
View this thread:
http://www.excelforum.com/showthread...hreadid=554374