Quote Originally Posted by 6StringJazzer View Post
I have read your post three times and I am unclear as to what your question is. What does this code do, and what do you want it to do instead? If you can answer that concisely then that will be a good title, see below.
Thank you! Please let me explain about this code.

I am responsible for maintaining secure data across 3 excel workbooks. These workbooks are the same, just that each one belongs to a specific team. Each workbook contains close to 60 sheets, many of which are hidden but necessary for pulling data.

Sheets A-Z are dedicated to individual team members and each sheet has a section dedicated to compliance tracking. The compliance name and due date are being pulled from a Master sheet named "." (just the period). The completion dates, however, will be different per individual since that information is manually input by each person upon completing compliances.

So this macro is supposed to run upon EITHER Open of the workbook OR when a person opens their sheet. It's supposed to check sheets A-Z for completion dates and due dates. If a due date is 10 business days away and no completion date has been entered, a pop-up reminder is supposed to appear for that individual's sheet. Example: Taylor's sheet is G and has a due date coming up in 10 days but he hasn't entered a completion date yet. When Taylor accesses his sheet, G, the pop up should appear. If a completion date has not been entered and the due date is now in 3 business days, the reminder should appear. Once Taylor enters a completion date, that pop-reminder should NOT appear for that particular compliance. He may have others that are due in X number of days requiring a reminder.

I hope this is making sense. I've included the snippets of the sheets below:


Snippet 1: This is to show how the compliance data looks in the workbook on both the Master sheet and sheets A-Z. The only part of this that is NOT included in the Master sheet is the completion date as it's not needed on the Master.
Attachment 709087


Snippet 2: This is to show the sheet tabs along the bottom of the workbook. Please keep in mind that are many hidden sheets. I only have the necessary ones visible for management and team purposes.
Attachment 709088

And the sheet/column/cell range references for my needs are:

1- Completion Date is in column B in the range B19:B32 – Pulling from sheets A-Z, Range AZ19:AZ50

2- Due Date is in column C on similar range C19:C32 – Pulls from hidden sheet “.” Range J14:J45

3- Item/compliance is in column A on similar range A19:A32 – Pulls from hidden sheet “.” Range C14:C45 OR Pulls from sheets A-Z, range AV19:AV50

4 - 26 of the total sheets on your workbook are named with the alphabet letters from A to Z - Do I have to update this in the code somewhere?