Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Execel file auto save
Hi,
Is there any way that an excel sheet automatically saves the changes everytime some/any modification is done? I am not asking about the auto save option (which is selected after sharing the workbook) which saves the sheet every 5 min (or any specified time). -- Cheers! Sam |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Execel file auto save
If you mean to save as soon as a change is made then try the below code. Set
the security level to low/medium in (Tools|Macro|Security). From workbook press Alt+F11 to launch VBE (Visual Basic Editor). From the left treeview search for the workbook name and click on + to expand it. Within that you should see the following VBAProject(Your_Filename) Microsoft Excel Objects Sheet1(Sheet1) Sheet2(Sheet2) Sheet3(Sheet3) This Workbook Double click 'This WorkBook' and paste the below code to the right code pane. Private Sub Workbook_SheetChange(ByVal Sh As Object, ByVal Target As Range) If ThisWorkbook.Saved = False Then ThisWorkbook.Save End Sub 'or if you want to save just before close...try the below Private Sub Workbook_BeforeClose(Cancel As Boolean) If ThisWorkbook.Saved = False Then ThisWorkbook.Save End Sub If this post helps click Yes --------------- Jacob Skaria "Sam" wrote: Hi, Is there any way that an excel sheet automatically saves the changes everytime some/any modification is done? I am not asking about the auto save option (which is selected after sharing the workbook) which saves the sheet every 5 min (or any specified time). -- Cheers! Sam |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
no auto sum formulas remain when I save to different file name | Excel Discussion (Misc queries) | |||
Can I auto save to a separate file?(not the file I am working in) | Setting up and Configuration of Excel | |||
Auto save file copy with unique filename | Excel Worksheet Functions | |||
auto save excel file every 10 minutes to its original file name | Excel Discussion (Misc queries) | |||
How do I "auto save" my file in MsOffice2003 Exel? | Charts and Charting in Excel |