Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Big fella
 
Posts: n/a
Default 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   Report Post  
Vacation's Over
 
Posts: n/a
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel Date Format - users should be able to override it automatic. jamezog Excel Discussion (Misc queries) 7 May 20th 10 02:45 PM
Excel 2K3: Opening a spreadsheet, also opens book1.xls? Newtek Excel Discussion (Misc queries) 3 July 6th 05 07:56 PM
Excel 2K3: Opening spreadsheet, also opens book1.xls? Newtek Setting up and Configuration of Excel 1 July 6th 05 07:56 PM
calculating excel spreadsheet files for pensions and life insurance (including age calculation sheets) RICHARD Excel Worksheet Functions 1 March 15th 05 05:49 PM
Creating a Date Selector in Excel VBA? Mark Excel Discussion (Misc queries) 0 November 25th 04 10:59 PM


All times are GMT +1. The time now is 12:04 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"