Workbook Refreshes For Multiple Users
 

I'm using this to create new workbooks.
The workbook gets re-saved every every few seconds.
Is it possible to allow another user to have this workbook open and see the
changes as they are happening ?

I tried the "External Data" but could not get it to work.


Sheets(Array("strings")).Select
Sheets("strings").Activate
ChDir "J:\PROJECTS\Carl\New Folder"
Dim sh As Worksheet
Dim Nwb As Workbook
Application.ScreenUpdating = False
For Each sh In ActiveWindow.SelectedSheets
sh.Copy
Set Nwb = ActiveWorkbook
Nwb.SaveAs Filename:=sh.Name
Nwb.Close False
Next

Thank you in advance.