View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Kevin B Kevin B is offline
external usenet poster
 
Posts: 1,316
Default Disable Autosave via Code

You can place this in the Workbook module to uninstall on open and reinstall
before close.

Private Sub Workbook_BeforeClose(Cancel As Boolean)

AddIns("Autosave Add-in").Installed = True

End Sub

Private Sub Workbook_Open()

AddIns("Autosave Add-in").Installed = False

End Sub

--
Kevin Backmann


"John Daily" wrote:

How can I disable Excel's Autosave programaticaly? With code that I can put
in the spreadsheet whenever it is opened? I don't want to have to turn it
off via Excel as this is too much of a problem for the 10 users that touch
the spreadsheet. We are running Excel on several citrix servers and it's too
much work to turn it off everytime a user open's Excel.


Thanks,

John