Hello,
Is it possible to create more users for an excel workbook, and to be able to track who modified in it ? ..
Thx,
Nedy
Hello,
Is it possible to create more users for an excel workbook, and to be able to track who modified in it ? ..
Thx,
Nedy
It is using a shared workbook, but the sahred workbook implementation is severely flawed, and IMO is not worth the effort. It is better to come up with another way, maybe an Access solution, or an Accss database front-ended by an Excel addin.
____________________________________________
Nihil simul inventum est et perfectum
Abusus non tollit usum
Last night I dreamed of a small consolation enjoyed only by the blind: Nobody knows the trouble I've not seen!
James Thurber
yes, i think you try to this:
[VBA] ActiveWorkbook.KeepChangeHistory = True
ActiveWorkbook.ChangeHistoryDuration = 30
ActiveWorkbook.SaveAs Filename:="C:\common_used.xls", AccessMode:=xlShared[/VBA]
L@ja