Is it possible to use VBA to disable the Save andSave As... functions in Excel for a particular application?
I was thinking of something like this, placed in the ThisWorkbook VBA module:
I am not sure of the exact syntax but basically that describles what I want to do. Would this work, or is there a better way of doing it?Code:On ApplicationSave MsgBox "Application cannot be saved" Close Workbook
Thanks
-Rob




Reply With Quote