using "save date" in excel.

leviavnon · #1 06-13-2016, 03:47 AM

Is there any way to plant in Excel, an equivalent of the word field :
{ savedate.....mergeformat } ?
-An automatic date that will change each time I save the file?
I tried a simple copy. Didnt work.
please help.

Levi

jeffreybrown · #2 06-13-2016, 04:39 AM

Hello Levi & Welcome to the Forum,

You would have to use code...

Something like this placed in the ThisWorkbook module

Code:

Private Sub Workbook_BeforeSave(ByVal SaveAsUI As Boolean, Cancel As Boolean)
    Sheets("Sheet1").Range("A1").Value = Now
End Sub

http://www.rondebruin.nl/win/code.htm

leviavnon · #3 06-14-2016, 11:34 PM

Hi Jeffrey

thats above my level.
Many thanks.
Levi

KunleExcel · #4 06-15-2016, 08:02 AM

You can use Today function: =today()

leviavnon · #5 06-16-2016, 07:52 AM

many thanks, I wanted a solution simmilar to "save date" like in "word".
appreciate your time.
Levi.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
How to use a "Save As" button without causing digital signatures to become "Invalid"?	jferg	Word VBA	0	02-16-2016 03:04 PM
When using "Save and Send" from Excel 2010, the email opens with no ribbons and seems to hang.	bjsusol	Outlook	1	03-31-2015 11:03 PM
Disable "Save" & "Save As" & "Print" ribbon	Villalobos	Word VBA	3	07-14-2014 11:37 PM
How to "deactivate" the Excel's SAVE function	KIM SOLIS	Excel	1	11-05-2011 01:57 AM
"Microsoft Excel Application" missing in the "Component Services" on win08	sword.fish	Excel	0	02-26-2010 02:09 PM