View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
JE McGimpsey JE McGimpsey is offline
external usenet poster
 
Posts: 4,624
Default 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