Issues saving Protected .xlam

[Todkerr]

Hi all.

I have an .xlam file that is password protected for viewing.

At times the .xlam accepts user inputs and saves itself to archive the inputs. (This is accomplished with simple thisworkbook.save statements in applicable code, as well as a redundant worksheet_save private function for the edited worksheet.)

If I exit out of Excel by closing the Excel window, Excel generates the customary "save?" queries for open and unsaved workbooks. Then at the end of clearing that out, Excel requires the password for the .xlam file - which I do not want to happen, of course.

I have added statements like "thisworkbook.saved = true" to run when the .xlam is edited - and I know that those statements are executing (as well as the thisworkbook.save statements) since subsequent code send flags to the debugger indicating that it ran.)

If I remove the password protection from the .xlam and close Excel under the same conditions, I do NOT get a request to save changes to the .xlam.

So with the password prtection on, Excel sees the .xlam file as NOT saved. Without the password, Excel sees the .xlam as saved.


Anyone have thoughts on how to work around this problem? A fairly lengthy on-line search did not show show help for the exact same problem.

Many thanks in advance.

 

[Fluff]

Duplicate https://www.mrexcel.com/forum/excel-questions/1038559-issues-saving-protected-xlam.html

Please do not post the same question multiple times. All clarifications, follow-ups, and bumps should be posted back to the original thread. Per forum rules, posts of a duplicate nature will be locked or deleted (rule 12 here: Forum Rules).

Note that sometimes posts from new users require Moderator approval before you can see them on the public forums. When this happens, you should see a message to that effect when you try to post it. Please be patient and do not attempt to post the question again.