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

's Computer Specifications

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 Computer Specifications

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

's Computer Specifications

Post your code.

Gord Dibben MS Excel MVP

On Mon, 23 Jun 2008 08:10:25 -0700, saran <(E-Mail Removed)>
wrote:

> 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.
>

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
auto update of date and time whenever changes are made to a xcel s	saran	Microsoft Excel Worksheet Functions	9	23rd Jun 2008 02:44 PM
Update auto checked but date and time do not update when I reopen	=?Utf-8?B?bWdyYXk=?=	Microsoft Word Document Management	1	2nd Feb 2007 03:46 AM
Date & Time auto update	=?Utf-8?B?SmFja2llIEQ=?=	Microsoft Word Document Management	5	7th Apr 2005 09:49 AM
Re: Auto Update Date And Time	TF	Microsoft Word New Users	0	31st Aug 2004 02:23 PM
Re: Auto Update Date And Time	Suzanne S. Barnhill	Microsoft Word New Users	0	31st Aug 2004 02:14 PM