VBA & Macro Problems

How to Send an Email When a Specific Excel Row Changes

Olivia Miller Sep 25, 2026 869 views

Question details

The user wants to receive an email alert only when a specific row in a shared Excel workbook is modified by other employees.

How to Send an Email When a Specific Excel Row Changes

Product: Excel
Device & OS: not provided
Scenario: Sharing a workbook with employees where specific rows need monitoring without getting alert spam for every single edit made in the file.
Observed behavior: Native OneDrive file notifications alert users for any change in the shared workbook, lacking the functionality to natively target and monitor a single row or cell range.

Before you start

Ensure your workbook is saved as a Macro-Enabled Workbook (.xlsm) if you plan to use VBA, and verify that you have an active Outlook desktop client configured to send automated messages.

Solution 1Recommended

Use VBA to Trigger an Email on Row Change

Utilize Excel VBA's Worksheet_Change event to automatically draft and send an email when cells in a specific row are edited.

VBA (Visual Basic for Applications) provides the most precise control over cell monitoring. By combining the Worksheet_Change event with Outlook automation, you can send instant alerts when a specific row is modified.

Open the VBA Editor

Open your target workbook, right-click the specific sheet tab at the bottom of the screen, and select 'View Code' to launch the VBA Editor.

Set Up the Worksheet Change Event

In the code window, select 'Worksheet' from the left dropdown menu and 'Change' from the right dropdown menu to create a Private Sub Worksheet_Change(ByVal Target As Range) block.

Define the Target Row

Enter an IF statement using Intersect to check if the edited cell falls within your target row. For example: If Not Intersect(Target, Range("5:5")) Is Nothing Then.

Add Outlook Automation Code

Within the IF condition, use CreateObject("Outlook.Application") to create an email item, set the .To, .Subject, and .Body properties, and trigger the .Send command.

Save as Macro-Enabled

Go to File > Save As and ensure the file format is set to Excel Macro-Enabled Workbook (*.xlsm) so the code runs successfully in the future.

Use VBA to Trigger an Email on Row Change

Macro Security: Employees editing the file must have macros enabled in their Excel application, otherwise the VBA script will not trigger the email.

Solution 2

Use Power Automate for Cloud-Based Excel Files

Use Microsoft Power Automate to monitor an Excel table stored in OneDrive or SharePoint and trigger an email when a row is modified.

Solution 3

Workaround: Use Allow Edit Ranges with OneDrive Notifications

Restrict editing in the worksheet to specific ranges so that general file notifications only trigger when relevant changes occur.

Advanced Spreadsheets with WPS Office

Easily Manage Macros and Cell Tracking with WPS Spreadsheet

WPS Spreadsheet offers robust support for VBA macros and seamless compatibility with Microsoft Excel formats. You can easily implement row-tracking scripts, protect specific ranges, and collaborate efficiently without hefty subscription fees.

1. Download WPS Office: Download and install WPS Office for free from the official website.
2. Open Your Macro File: Open your .xlsm file using WPS Spreadsheet to retain all macro functionality.
3. Access the VBA Editor: Navigate to the Developer tab or Tools tab to access the VBA Editor and manage your automated email scripts effortlessly.
4. Protect Specific Ranges: Use the Review tab to quickly configure 'Allow Users to Edit Ranges' and apply 'Protect Sheet' to restrict unwanted modifications.

Full compatibility with Microsoft Excel (.xlsx, .xlsm, .csv) formats.Built-in VBA editor to easily implement Worksheet_Change events and automated emails.Advanced sheet protection features to lock specific ranges and manage employee edits.Free and lightweight office suite for seamless daily collaboration.

microsoft office alternative - wps office

Frequently Asked Questions

Why doesn't OneDrive let me set an alert for just one cell?

OneDrive's built-in alert system is designed to monitor file-level changes (like file creation, deletion, or any modification). It does not have the native granularity to inspect internal workbook contents like individual cells or rows.

Do employees need to have Macros enabled for the VBA email trigger to work?

Yes, if you use the VBA method, the user making the change must have macros enabled in their Excel application. Otherwise, the Worksheet_Change event will not trigger, and the email will not be sent.

Can I send the email to different addresses based on which row is changed?

Absolutely. Using VBA or Power Automate, you can set up conditional logic (If/Then statements) that checks the row number or cell value and dynamically changes the recipient email address accordingly.

Will the Power Automate method work with a standard Excel file not saved in the cloud?

No, Power Automate requires the Excel file to be stored in a cloud location like OneDrive for Business or SharePoint, and the data must be formatted as an Excel Table for the connector to read row updates.

Excel & Data Problems