VBA & Macro Problems

How to Record Who Clicked a Checkbox During Excel Co-Authoring

Tauseeq MagsiTauseeq Magsi Nov 3, 2026 869 views

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.

How to Record Who Clicked a Checkbox During Excel Co-Authoring
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 you start

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.

Solution 1Recommended

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.

1
Create a drop-down list

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.

2
Require name selection

Instruct your team to manually select their name from the drop-down menu immediately before or after checking the task box.

3
Log the timestamp

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.

Implement a Manual User Selection Field
VBA Limitations in Co-authoring: Excel macros are generally not optimized for simultaneous co-authoring environments like Microsoft Teams. Relying on manual input reduces synchronization errors.
Free Microsoft Office alternative

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. 1. Download WPS Office: Visit the official WPS website and download the free WPS Office suite for your operating system.
  2. 2. Open Your Existing Workbook: Launch WPS Spreadsheets and open your .xlsx task tracker. WPS retains your original formatting and data layouts.
  3. 3. Collaborate Effectively: Utilize WPS Office's intuitive interface to manage data validation, drop-downs, and shared tracking safely.
Fully compatible with Microsoft Excel formats (.xlsx, .xls, .csv).Lightweight application that runs smoothly on all devices without heavy resource usage.Free to use with a familiar, user-friendly tabbed interface that requires no learning curve.Supports essential formulas, data validation, and core collaborative spreadsheet functions.
microsoft office alternative - wps office

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.