Yes, just run the code if today's date is not in the cell.......
Yes, just run the code if today's date is not in the cell.......
if the macro is run today and 5/22/2018 is in the cell, then the file opened tomorrow (5/23) will the macro run? Our Finance department will open the file and use it multiple times.
If you want it only to run once, when the workbook is opened, it will check if the cell has today date in it, if not, then it will run the code, and place the date in the cell, so that next time the wb is opened, if first checks the date of the cell to see if it has to run the code or not.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks