Excel's Autosave bypasses my application's security.  How do I disable Autosave using VBA?

LarryRW
LarryRW used Ask the Experts™
on
Excel's Autosave bypasses my application's security.  How do I disable Autosave using VBA?

Thank you,
Larry
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®

Author

Commented:
Is this the way ?

call autosave(true)

Sub AutoSave(Setting As Boolean)
Workbooks("autosave.xla").Excel4IntlMacroSheets("Loc Table") _
.Range("ud01n.Do_Save").Value = Setting
Run "autosave.xla!mcs05.ClearOnTime"
Run "autosave.xla!mcs03.SetOnTime"
Run "autosave.xla!mcs01.CheckCommand"
End Sub


Larry
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

Author

Commented:
There were several codes.  I will try them ASAP - then SQA on the way.  I did search; however, I did not find the code you referenced.

Thank you,
Larry

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial