GhostWatch
New Member
- Joined
- May 26, 2023
- Messages
- 7
- Office Version
- 365
- Platform
- Windows
Im making a VBA macro that sends an emil out when a cell turns red. The cell turns red using a conditional formatting that changes from blank to red after 11months since the date inputted.
When the cells are automatically change then it registers it and sends the email, however it does not register it if the color was changed automatically.
Is this something wrong with my code, or just a way excel works?
When the cells are automatically change then it registers it and sends the email, however it does not register it if the color was changed automatically.
Is this something wrong with my code, or just a way excel works?