Does anyone know exactly how form controls (e.g. checkboxes) work when co-authoring.
I don't link them to a cell and use an assigned macro to get the checkbox status directly from the object
(cbValue = Worksheets("APRA CPG 234 Tracking").Shapes("CheckBoxName").ControlFormat.Value).
So the question is two-fold:
1. If one concurrent user checks the checkbox, will that action also change the checked status on other users' sessions?
2. When the workbook is saved and closed, does the current user's checkbox setting save, perhaps overwriting another user's saved checkbox status.
I suspect the answer to the 2nd question is yes, but the more important question is #1, what happens when mupltiple concurrent users change a form control checkbox.
I use these checkboxes to set filters on hidden, help columns in a table so, if I'm right about my assumption with saving the workbook, my only pragmatic solution would be to reset all the checkboxes to uncheck before saving the workbook. At least then everyone will start from a known filtering point when they open the workbook. Having said that, the autosave, which is key to co-authoring my screw up that idea, so I'd be interested in other ideas to address the issue. I'm already using personal Sheet Views, That are set when opening the workbook based on the logon full name. I use this to prevent everyone working in the same view and suffering the dynamic updated when someone else changes the filtering. Personal views allows individual filters, hidden rows and columns, while reflecting any value changes. Hey! maybe co-authoring and Sheet views is clever enough to allow unique forms control statuses within each view, but I can't find anything that suggests either way.
Thx in advance,
I don't link them to a cell and use an assigned macro to get the checkbox status directly from the object
(cbValue = Worksheets("APRA CPG 234 Tracking").Shapes("CheckBoxName").ControlFormat.Value).
So the question is two-fold:
1. If one concurrent user checks the checkbox, will that action also change the checked status on other users' sessions?
2. When the workbook is saved and closed, does the current user's checkbox setting save, perhaps overwriting another user's saved checkbox status.
I suspect the answer to the 2nd question is yes, but the more important question is #1, what happens when mupltiple concurrent users change a form control checkbox.
I use these checkboxes to set filters on hidden, help columns in a table so, if I'm right about my assumption with saving the workbook, my only pragmatic solution would be to reset all the checkboxes to uncheck before saving the workbook. At least then everyone will start from a known filtering point when they open the workbook. Having said that, the autosave, which is key to co-authoring my screw up that idea, so I'd be interested in other ideas to address the issue. I'm already using personal Sheet Views, That are set when opening the workbook based on the logon full name. I use this to prevent everyone working in the same view and suffering the dynamic updated when someone else changes the filtering. Personal views allows individual filters, hidden rows and columns, while reflecting any value changes. Hey! maybe co-authoring and Sheet views is clever enough to allow unique forms control statuses within each view, but I can't find anything that suggests either way.
Thx in advance,
