A
Abel Chan
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 other’s 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
user’s changesâ€.
Do you have any idea to do this?
Thanks.
Abel
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 other’s 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
user’s changesâ€.
Do you have any idea to do this?
Thanks.
Abel