Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Share workbook update changes setting
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Share a workbook | Excel Worksheet Functions | |||
update interval in excel share | Excel Programming | |||
How can I share and un-share a workbook using a macro? | Excel Programming | |||
Can't share workbook. The "Share Workbook" option is off. Why? | Excel Discussion (Misc queries) | |||
HOW TO EDIT THE UPDATE CHANGES ON ADVANCED TAB IN SHARE WORKBOOK | Excel Worksheet Functions |