Hi there,

I created an Excel share workbook so that a domain group can have
read/write privilege and others have read only privilege. So far it works
OK. Changes from a read/write user were able to propagate to a read only
user.

My remaining question is to know if there is a way, through VBA or
something, to set up the Share Workbook | Advanced | Update changes setting
for these two groups. BTW, I already know how to distinguish between these
two groups by using the Active DS Type library.

My vision is when the read/write group opens the share workbook, a macro/VBA
code is able to set up the Update changes setting to €œAutomatically every 5
minutes€� plus €œSave my changes and see others changes€�.

When the ready only group opens the share workbook, the Update changes
setting will set to €œAutomatically every 5 minutes€� plus €œJus see other
users changes€�.

Do you have any idea to do this?

Thanks.

Abel