Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Date stamp spreadsheet in excel to remind me of completion date
is it possible to have a date stamp imbeded in a spreadsheet so that progress
on any work can be prompted. Can the spreadsheet be linked to an electronic calendar so it send you an auto reminder to open that spreadsheet at a certain date & time. |
#2
|
|||
|
|||
Date stamp spreadsheet in excel to remind me of completion date
generally speaking code needs to be open to run.
a file cannot open itself That said, if you want to put a macro in Personal.XLA that checks the date and time and then selects files to open that can be accomplished. This will not run unless Excel is open. two ways to run this would be the personal.xla Open event to check each time you launch Excel or the "ontime" function that will check every ___ min or hours to see if something needs to be done. "Big fella" wrote: is it possible to have a date stamp imbeded in a spreadsheet so that progress on any work can be prompted. Can the spreadsheet be linked to an electronic calendar so it send you an auto reminder to open that spreadsheet at a certain date & time. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel Date Format - users should be able to override it automatic. | Excel Discussion (Misc queries) | |||
Excel 2K3: Opening a spreadsheet, also opens book1.xls? | Excel Discussion (Misc queries) | |||
Excel 2K3: Opening spreadsheet, also opens book1.xls? | Setting up and Configuration of Excel | |||
calculating excel spreadsheet files for pensions and life insurance (including age calculation sheets) | Excel Worksheet Functions | |||
Creating a Date Selector in Excel VBA? | Excel Discussion (Misc queries) |