Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
set cell to today's date macro
I have a workbook where i want the date to be set in cell b23 to todays date every time the wkbook is opened
also every sheet in the workbook has a cell which requires this date but they are not all b23 can this be don any help appreciate |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
set cell to today's date macro
Colm
In the ThisWorkbook Module: Private Sub Workbook_Open() With ThisWorkbook .Sheets("Sheet1").Range("B23") = Date .Sheets("Sheet2").Range("A23") = Date .Sheets("Sheet3").Range("A2") = Date 'etc End With End Sub -- HTH Roger Shaftesbury (UK) "Colm O'Brien" wrote in message ... I have a workbook where i want the date to be set in cell b23 to todays date every time the wkbook is opened. also every sheet in the workbook has a cell which requires this date but they are not all b23 can this be done any help appreciated |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
set cell to today's date macro
Thanks Roger that worked a trea
col |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
set cell to today's date macro
use the Workbook_Open event in the ThisWorkbook Module
http://www.cpearson.com/Excel/events.htm then include code like: worksheets("Sheet1").Range("B23").Value = Date worksheets("Sheet2").Range("C19").Value = Date or just set it for B23 and have formulas in the other sheets in the appropriate cells that point to B23 on Sheet1 (as an example. You might also look at the worksheetfunction =Today() maybe that will give you what you want without coding. -- Regards, Tom Ogilvy "Colm O'Brien" wrote in message ... I have a workbook where i want the date to be set in cell b23 to todays date every time the wkbook is opened. also every sheet in the workbook has a cell which requires this date but they are not all b23 can this be done any help appreciated |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I filter by today's date(changing) and before in a macro? | Excel Worksheet Functions | |||
Macro to jump to today's date | Excel Discussion (Misc queries) | |||
A macro for the today's date...not the current date | Excel Programming | |||
Macro to filter on today's date | Excel Programming | |||
Macro to filter on today's date | Excel Programming |