I am finding that using Excel 2007's Save Workspace command prompts the user to Save an XLAM file I have developed. I don't t believe this behavior existed in prior Excel versions. Is this normal? And, if it is, I don't think it should be, so is there a way to bypass (i.e, don't prompt and don't Save) such files, perhaps in a modified Save Workspace command?
I expect it will require re-purposing the Save Workspace command in the:
... which I can handle.
What I need assistance with is the code I would use to Save the Workspace without prompting for the Save of either xlam files or xla files (unless, perhaps, the files are open in the Excel Window by virtue of having their "IsAddin" property set to False ...).
Hope this is clear and I appreciate any insights.