Need help with BeforeSave script that makes the user continue to use the workbook after

Hi,

So, quick background story

I needed to secure my workbook the best way possible, in which I have done a good job except for one small "glitch" and that is if people want to save the workbook as an XLSX file and not a macro activated XLSM file, they are able to and can then access all the information that does not have macros in it.

So, I thought that I nice way to fix this was to make sure that I password protects all the sheets when users exit or save the workbook. In short:

If workbook is closed:

Please Login or Register  to view this content.

And Before saving:

Please Login or Register  to view this content.

So, the problem is basically with the last code... The code is working fine, but the problem is that if the user only wants to save the project and then continue working on it, he basically need to manually open all sheets again.
Now, I have a script that opens all sheets at startup of the workbook, but I do not want to force the user to exit the workbook every time he wants to save his work.


So, in short, is there a line or two that I can add to my code that makes it possible for the user to save his project and still be able to work in it (without manually opening all the sheets again) without exiting the file and reopen it again?

Thanks in advance for any help regarindg this issue

How about

Please Login or Register  to view this content.