View Single Post
Staro 20.08.2014., 00:52   #2
kepmip
Premium
Moj komp
 
kepmip's Avatar
 
Datum registracije: Dec 2008
Lokacija: Zagreb
Postovi: 169
ALT+F11 to open VB editor. double cick 'ThisWorkbook' and paste the code below in on the right. Change the range to where you want the date to be
Private Sub Workbook_BeforeSave(ByVal SaveAsUI As Boolean, Cancel As Boolean)
Sheets("Sheet1").Range("A1").Value = Date
End Sub


probal sam ovo, nekaj ne radi dobro, u čeliji mi piše samo 0:00:00, kad god da saveam dokument, a dok kliknem na nju, gore piše i datum, točan datum saveanja
kepmip je offline   Reply With Quote