Hi all,

I have a fantastic macro that exports and emails an action log to project managers based on their outstanding tasks. If a cell is red they have to complete the task, and if the cell is green the task doesn't show up in their workbook.

I need to figure out a way to communicate from their personal workbooks.xlsx to the parent "Project Tracker" without them having to open the primary workbook.

Currently, they can click on a hyperlink that directs them to the reference cell but ideally, I'd like the "hyperlink" to mark the parent cell green, update the date, and add the comment.


My fundamental question is, do I need to add a "personal.xlb" to each of their computers that can perform this macro, or do is there a work around?

Thanks in advance.

Alec