How do I put a "date & time saved" stamp inside an Excel Wksht?
maybe something like:
Private Sub Workbook_BeforeSave(ByVal SaveAsUI As Boolean, Cancel As Boolean) Worksheets("Sheet1").Range("A1") = Now() End Sub in the ThisWorkbook module in VBA. To open the VB editor, press Alt+F11 - Mangesh "Bill" wrote in message ... How do I put a "date & time saved" stamp inside an Excel Wksht? Is there a way to use programming and macros to do this? |
All times are GMT +1. The time now is 11:19 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com