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.
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.