| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
auto update of date and time whenever changes are made to a xcel s
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. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
auto update of date and time whenever changes are made to a xcel s
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 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
auto update of date and time whenever changes are made to a xcel s
Post your code.
Gord Dibben MS Excel MVP On Mon, 23 Jun 2008 08:10:25 -0700, saran 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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| auto update of date and time whenever changes are made to a xcel s | Excel Worksheet Functions | |||
| put date and time in cells after entry made in shared workbook | Excel Worksheet Functions | |||
| Formula that will record the time and date when an entry is made on a sheet | Excel Worksheet Functions | |||
| Last data entry made time and Date show in each worksheet | Excel Worksheet Functions | |||
| How to prevent file date change when no update made in Excel? | Excel Discussion (Misc queries) | |||
Linear Mode
