Disable Autosave via Code 1

[jdaily]

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

 

[PHV]

Application.AutoRecover.Enabled = False

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[jdaily]

Outstanding!! I was actually thinking that it was going to be much more difficult than one line.

Thank you.