| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Add date to cell with open macro
This should have been easy for me to figure out but I couldn't do it. I'm
just trying to have a cell auto-populate with the current date. I can't use the =today() function on the sheet because it changes the date on old copies when they are opened. I would like this to be a workbook_open macro that works with the one I have below to advance invoice dates. The cell I would like the date to populate in is M13. Thank, Duane. Private Sub Workbook_Open() Range("m3").Value = Range("m3").Value + 1 End Sub -- Message posted via OfficeKB.com http://www.officekb.com/Uwe/Forums.a...mming/200708/1 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Display Current Date & Time in a cell: Everytime I open the workbo | Excel Worksheet Functions | |||
| Open file if cell date is less than today+30 day? | Excel Worksheet Functions | |||
| Open an Excel file with a date as today in a macro | Excel Discussion (Misc queries) | |||
| open cell formationg dialogue from macro | Excel Programming | |||
| on open goto cell with today's date | Excel Programming | |||
Threaded Mode
