autoupdatesavechanges doesn't work
 

Hi all,
on an unshared workbook, I have this macro:

Sub Save()
Dim AutoUpdateSaveChanges As Boolean
Dim AutoUpdateFrequency As Long
ActiveWorkbook.AutoUpdateSaveChanges = True
ActiveWorkbook.AutoUpdateFrequency = 10
End Sub

when I try to execute it I see:
run-time error 1004 Method autoupdatesave cheanges on object _Workbook
failed.

How can I set this property?

TIA
CiccioSPICE

autoupdatesavechanges doesn't work
 

The property only applies to a shared workbook.

In article .com,
"CiccioSPICE" wrote:

Hi all,
on an unshared workbook, I have this macro:

Sub Save()
Dim AutoUpdateSaveChanges As Boolean
Dim AutoUpdateFrequency As Long
ActiveWorkbook.AutoUpdateSaveChanges = True
ActiveWorkbook.AutoUpdateFrequency = 10
End Sub

when I try to execute it I see:
run-time error 1004 Method autoupdatesave cheanges on object _Workbook
failed.

How can I set this property?

TIA
CiccioSPICE