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
|