How to Record Who Clicked a Checkbox During Excel Co-Authoring
Question details
The user wants to track which specific user clicked a checkbox to complete a task in a co-authored Excel workbook hosted on Microsoft Teams.

- Product
- Microsoft Excel
- Device & OS
- not provided
- Scenario
- Tracking weekly tasks using checkboxes and VBA in a shared workbook where multiple users co-author and edit simultaneously.
- Observed behavior
- VBA methods like Application.Username, Environ("UserName"), or Last Author fail to accurately capture the specific user who clicked the checkbox, instead logging the current local viewer or the last person to save the document.
Before modifying your shared workbook or implementing tracking scripts, pause live co-authoring temporarily to prevent macro conflicts while you set up your new tracking method.
Implement a Manual User Selection Field
Since automatic VBA username properties are unreliable during simultaneous editing, requiring users to manually select their name ensures accurate tracking.
During co-authoring, VBA functions like Environ("UserName") evaluate locally. This means they return the name of the person currently viewing the file, rather than the person executing the action remotely. Similarly, the Last Author property only updates upon saving, not when a specific cell is edited.
To accurately record actions without VBA conflicts, you should bypass these properties by requiring users to explicitly input their identity when completing a task.
Select the cell adjacent to your task checkbox. Go to the Data tab, select Data Validation, and create a drop-down list containing all team members' names.
Instruct your team to manually select their name from the drop-down menu immediately before or after checking the task box.
Use a standard Excel formula with circular references (if enabled) or a Worksheet_Change event tied to the drop-down cell to lock in the exact time the name was selected.

Migrate the Checklist to a Dedicated Collaborative Tool
Excel is primarily a spreadsheet tool. For tracking specific task ownership and completion times in a shared environment, a dedicated task management tool is more effective.
Try WPS Office for Seamless Spreadsheet Collaboration
If you are frustrated with the complexities of managing shared macros and trackers in your current setup, WPS Office offers a free, lightweight, and highly compatible alternative. Enjoy familiar spreadsheet tools, excellent format compatibility, and a smooth user experience.
- 1. Download WPS Office: Visit the official WPS website and download the free WPS Office suite for your operating system.
- 2. Open Your Existing Workbook: Launch WPS Spreadsheets and open your .xlsx task tracker. WPS retains your original formatting and data layouts.
- 3. Collaborate Effectively: Utilize WPS Office's intuitive interface to manage data validation, drop-downs, and shared tracking safely.

Frequently Asked Questions
Why does Environ("UserName") return the wrong name in a shared workbook?
In a co-authored environment, Environ("UserName") evaluates on each user's local machine. It will generally return the name of the person whose local Excel client is currently processing the calculation or viewing the sheet, rather than identifying the remote user who triggered a specific action.
Does the Last Author property update immediately when a checkbox is clicked?
No, the Last Author document property only updates when the workbook is successfully saved to the server. During live co-authoring, multiple people may edit the file before an auto-save triggers, making it impossible to attribute a specific checkbox click to the Last Author.
Can I use VBA to track when a formula recalculates?
No, Excel does not consider a cell to be 'changed' just because its formula recalculates a new result. Standard Worksheet_Change events only trigger when the cell's formula itself or the underlying raw data is manually edited by a user.




