Great

thanks for the feedback

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
www.nickhodge.co.uk
HIS


"kartune85" wrote
in message ...

I used:

Public NewBook As Workbook

..right at the the top of the page before any procedures. And In the
close procedure I put:

Sub CloseBook()
Set NewBook = Nothing
Application.DisplayAlerts = False
ThisWorkbook.Close
Application.DisplayAlerts = True
End Sub

It all works sweet now. Someone can now open multiple documents without
having conflict errors.

Thanks for your help.

Kartune85


--
kartune85
------------------------------------------------------------------------
kartune85's Profile:
http://www.excelforum.com/member.php...o&userid=35586
View this thread: http://www.excelforum.com/showthread...hreadid=554795