![]() |
i want to put a date into excel and then on that date be alerted
I am putting together a maintenance schedule worksheet on excel. As part of
this i wish to input future dates at which maintenance is required to be performed. The excel document will be a live document. Is it possible that, on the dates in question, i am alerted of the required maintenance with a message or alarm, potentially through oulook or any other programme. i.e. is there away that the date in the excel data box can be linked to an alert function? |
i want to put a date into excel and then on that date be alerted
I'm not sure if this is what you had in mind, but look at area #3 on this web
page: http://www.microsoft.com/atwork/getw...treamline.mspx tells how to set up Outlook tasks while you are in Excel. Another way would be to set up some code in the Excel workbook, probably in the Workbook_Open() or Worksheet_Activate() event that would look through the list of dates on a particular sheet and toss up a message to you when a date was 'today'. You'd have to open the workbook each day to get the alerts. "craign27" wrote: I am putting together a maintenance schedule worksheet on excel. As part of this i wish to input future dates at which maintenance is required to be performed. The excel document will be a live document. Is it possible that, on the dates in question, i am alerted of the required maintenance with a message or alarm, potentially through oulook or any other programme. i.e. is there away that the date in the excel data box can be linked to an alert function? |
All times are GMT +1. The time now is 10:01 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com