users access

[nedy_03]

Hello,

Is it possible to create more users for an excel workbook, and to be able to track who modified in it ? ..

Thx,
Nedy

[Bob Phillips]

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.

[L@ja]

yes, i think you try to this:
ActiveWorkbook.KeepChangeHistory = True
ActiveWorkbook.ChangeHistoryDuration = 30
ActiveWorkbook.SaveAs Filename:="C:\common_used.xls", AccessMode:=xlShared