| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Always open a certain worksheet if date is past?
Is there a macro or something that will open a specific sheet if a
date is past due? For example, if the date in cell C1 on sheet 1 is older than today, can the excel workbook always open to sheet 7 from that point forward? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Always open a certain worksheet if date is past?
Private Sub Workbook_Open()
If Sheets("Sheet1").Range("C1").Value < Date Then Sheets("Sheet7").Activate End If End Sub Place into Thisworkbook module. Gord Dibben MS Excel MVP On Tue, 24 Jul 2007 13:29:42 -0000, wx4usa wrote: Is there a macro or something that will open a specific sheet if a date is past due? For example, if the date in cell C1 on sheet 1 is older than today, can the excel workbook always open to sheet 7 from that point forward? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Copy and past from one worksheet to another | Excel Discussion (Misc queries) | |||
| Protect Worksheet from Copy Past | Excel Discussion (Misc queries) | |||
| When I open my past invoice it keeps changing date to todays date | Excel Worksheet Functions | |||
| need to show when date is past due | Excel Worksheet Functions | |||
| Date/If function for past dues | Excel Worksheet Functions | |||
Linear Mode
