Date in exel worksheet?

need to add a date to a cell in exel the spreadsheet is viewed by others under the read only rules. i want the date to alter everytime it is saved by me , i don't want the date to alter when it is just opened using read only by others, i have tried using =now() but this alters when it is read by others , i just want it to alter when it is saved by me

Date in exel worksheet?
I don't put my dates in cells on the sheet, I put mine in the footer on the left hand side "Last updated XX-XX-XX". I also put the location of the saved workbook in the footer on the right hand side along with my name. It helps others know who created it and it helps you remember where you saved it.
Reply:Change the rights on the file to read only


right click the file and click the read only.





If it is on a server you might be able to set access levels to the file so that nobody but you can edit it and save changes..
Reply:Try this :





Private Sub Workbook_BeforeSave(ByVal SaveAsUI As Boolean, Cancel As Boolean)


Worksheets("sheet1").Range("a1").Value = Now


End Sub





and look at this website boo...





http://www.mrexcel.com/archive/Dates/ind...








Good luck
Reply:you can't, if its opened the date will change