Updating a shared workbook every 30 secs?
 

Using Excel XP. I am creating a shared workbook, no problem here. However,
the update option in the [Advanced] tab can be set to nothing less than 5
minutes. Is there a way to automatically update every 30 secs or so? or, Is
there some VBA coding I could use to remind the user to save the changes
after they update the workbook?

Thank for any help.

Updating a shared workbook every 30 secs?
 

If you press Alt+F11 and then double click on the ThisWorkbook icon in the
Project window on the left. In the code pane to the right, change the first
combo box at the top to Workbook and the combo box to the right to
SheetChange and enter the following code:

ThisWorkbook.Save

The code should look like the lines below.

Private Sub Workbook_SheetChange(ByVal Sh As Object, ByVal Target As Range)

ThisWorkbook.Save

End Sub

This save the workbook with each change on any sheet.

However, if this is large workbook it could prove to be too time consuming.
--
Kevin Backmann


"Ricoy-Chicago" wrote:

Using Excel XP. I am creating a shared workbook, no problem here. However,
the update option in the [Advanced] tab can be set to nothing less than 5
minutes. Is there a way to automatically update every 30 secs or so? or, Is
there some VBA coding I could use to remind the user to save the changes
after they update the workbook?

Thank for any help.

Updating a shared workbook every 30 secs?
 

I'll try it... it is a very small workbook... under 50K

Thank you

"Kevin B" wrote:

If you press Alt+F11 and then double click on the ThisWorkbook icon in the
Project window on the left. In the code pane to the right, change the first
combo box at the top to Workbook and the combo box to the right to
SheetChange and enter the following code:

ThisWorkbook.Save

The code should look like the lines below.

Private Sub Workbook_SheetChange(ByVal Sh As Object, ByVal Target As Range)

ThisWorkbook.Save

End Sub

This save the workbook with each change on any sheet.

However, if this is large workbook it could prove to be too time consuming.
--
Kevin Backmann


"Ricoy-Chicago" wrote:

Using Excel XP. I am creating a shared workbook, no problem here. However,
the update option in the [Advanced] tab can be set to nothing less than 5
minutes. Is there a way to automatically update every 30 secs or so? or, Is
there some VBA coding I could use to remind the user to save the changes
after they update the workbook?

Thank for any help.