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
|