The idea is that i'm doing a checklist(Workbook 2). On workbook 1 I have a macro where people select an item from a drop-down box (B2) and click a command button to send an email. What I want to do within the email macro, is call another macro that opens up workbook 2 and "checks off" ("x") the selected item from workbook 1. Workbook 2 has all of the possible items in column A while in column B is left for the check-offs. I cannot find anything on google to point me in the direction on how to execute this. I believe I'd be able to figure this out if I could just do it on a different sheet within workbook 1, but the workbook has to be a read-only file. Is there anyone that can help point me in the right direction? Thank you!
Bookmarks