Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
is it possible to set popup reminders in a excel worksheet
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
is it possible to set popup reminders in a excel worksheet
Yes
Gord Dibben MS Excel MVP On Thu, 31 Jan 2008 20:33:01 -0800, ed wrote: |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
is it possible to set popup reminders in a excel worksheet
On 1 Feb, 17:09, Gord Dibben <gorddibbATshawDOTca wrote:
Yes Gord Dibben MS Excel MVP On Thu, 31 Jan 2008 20:33:01 -0800, ed wrote: How do you want the popup reminders to function exactly? Do you want them to pop up when the workbook is opened, or following a particular event, such as entering data into a specific cell. Please give us more details so that we can help. Regards, Matt Richardson http://teachr.blogspot.com |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
is it possible to set popup reminders in a excel worksheet
Hopefully, this is not off topic. Here is my scenerio:
have a excel spreadsheet that contains the date a request is received and the date the request is due to the customers. How do I create a popup that alerts the user three days prior to the due date, which request are due? I will need for the popup to activate everytime the spreadsheet is opened. Thanks you much -- tmdrake "Matt Richardson" wrote: On 1 Feb, 17:09, Gord Dibben <gorddibbATshawDOTca wrote: Yes Gord Dibben MS Excel MVP On Thu, 31 Jan 2008 20:33:01 -0800, ed wrote: How do you want the popup reminders to function exactly? Do you want them to pop up when the workbook is opened, or following a particular event, such as entering data into a specific cell. Please give us more details so that we can help. Regards, Matt Richardson http://teachr.blogspot.com |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
is it possible to set popup reminders in a excel worksheet
On Friday, February 1, 2008 9:09:59 PM UTC+4, Gord Dibben wrote:
Yes Gord Dibben MS Excel MVP On Thu, 31 Jan 2008 20:33:01 -0800, ed wrote: Sir, I want to creat a popup reminder when we open worksheet, like every wednesday & thursday like " report to be sent urgently", u can specify cell A1 or any for values pls reply |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
is it possible to set popup reminders in a excel worksheet
Add this to Thisworkbook module if you mean when you open workBOOK.
Private Sub Workbook_Open() If Weekday(Now) = 4 Or Weekday(Now) = 5 Then MsgBox "send report immediately" End If End Sub If you really meant workSHEET then ignore above and add this to worksheet module. Private Sub Worksheet_Activate() If Weekday(Now) = 4 Or Weekday(Now) = 5 Then MsgBox "send report immediately" End If End Sub Gord On Wed, 31 Jul 2013 23:39:20 -0700 (PDT), wrote: On Friday, February 1, 2008 9:09:59 PM UTC+4, Gord Dibben wrote: Yes Gord Dibben MS Excel MVP On Thu, 31 Jan 2008 20:33:01 -0800, ed wrote: Sir, I want to creat a popup reminder when we open worksheet, like every wednesday & thursday like " report to be sent urgently", u can specify cell A1 or any for values pls reply |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
HOW TO SET UP REMINDERS IN EXCEL? | Excel Worksheet Functions | |||
Setting up Popup-Task type reminders In Excell 2003. | Excel Discussion (Misc queries) | |||
How do I set up Reminders in an excel spreadsheet? | Excel Worksheet Functions | |||
How do I set up Reminders in an excel spreadsheet? | Excel Worksheet Functions | |||
Can I set date reminders in MS Excel? | Excel Discussion (Misc queries) |