Aug 07 2017 02:18 PM
Is there a way to add a date or calendar to a spreadsheet and have a reminder pop up on my screen even when I am not in Excel?
Lets say I have to file an inspection by a certain date or someone's permit is expiring, I want to have a reminder pop up that will tell me to look at the spreadsheet and update it or take care of whatever needs to be taken care of. Thanks!
Aug 07 2017 03:20 PM
Hi Marti,
If only with some programming. If Excel opened VBA script will be enough. If for closed workbook some external script (e.g. powershell) which will check your data in a loop.
That's not from the box.
Aug 07 2017 09:29 PM - edited Aug 07 2017 09:30 PM
Hello,
set up a task in Outlook. That will pop up regardless of Excel being open or closed and does not need any complicated VBA. Work smarter, not harder :)