| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Footer, "fixed" date
In part of my footer macro, (see below) I need a fixed date
- ie: current date, that does not change when I open the file again on a different date. The only time the date should change is when I run the macro again, at some future time, which I would do after making a change to the form. Currently I go in every morning and change the date in the macro. There must be a way to get the current date VALUE only, to accomplish what I need. ..LeftFooter = "&""Arial,Bold""&8Oct. 26, 2004" & Chr(10) & "JFS" John F. Scholten |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| creating a "date selector box" or "pull down box" in a cell | Excel Worksheet Functions | |||
| Convert numbers to date: "586" to read "May 1986" | Excel Worksheet Functions | |||
| Excel - Golf - how to display "-2" as "2 Under" or "4"as "+4" or "4 Over" in a calculation cell | Excel Discussion (Misc queries) | |||
| xy plot line style change when I select "fixed maximum" | Charts and Charting in Excel | |||
| Showing "Created by User, Date, Time" in Footer | Excel Discussion (Misc queries) | |||
![John F[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
