I have a file that I send out to users on a monthly basis, and there are a few key cells that some controllers leave blank.
Is there a code that if, lets say, cell D8 is blank, that before they close the file, a message box pops up and says a brief message to them as a reminder to fill that cell in, and to make sure that they have filled in all variance explanations?
And if they press ok, it copies and pastes the name in Cell D8 from the active page, and selects a sheet in the workbook called "TitlePage", and pastes the name and current date and time (value only so it doesn't change) into Cell E47 on the title page?
Is there a code that if, lets say, cell D8 is blank, that before they close the file, a message box pops up and says a brief message to them as a reminder to fill that cell in, and to make sure that they have filled in all variance explanations?
And if they press ok, it copies and pastes the name in Cell D8 from the active page, and selects a sheet in the workbook called "TitlePage", and pastes the name and current date and time (value only so it doesn't change) into Cell E47 on the title page?