auto update of date and time whenever changes are made to a xcel s

S

saran

Hi..
In the case of using auto update program for date and time thro vba editor,
the following error occurs
run time error 9.
This problem is more predominant in excel having more than one sheet.
Can u pl suggest what may b the problem.
 
S

sivak

Try this code. Put this code in the ThisWorkbook object.

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

auto update of date and time whenever changes are made to a xcel s 9
problem with auto update of date and time 1
Auto Date/Time whenever a record changes 10
Prompted to save changes when no changes are made 15
Please help with auto Date and Time with VBA 6
help to in setting up a proper Vlookup table and formula 4
Automatically enter date and time but only update once. 3
Is there a way to set up a one-time default date? 1

Top