Disabling save as option to protect macro code

I have a macro file which as has a button which, when clicked, fetch data from Master data tab based on the user's access level. Access is defined under Access tab. Both Access tab and Master Data tab are "VeryHidden" in VBA editor and protected by password so that user can't access it.

Now the issue is, if i save the file as xlsx or other format macro code including password is getting removed. Then i can make Master data tab visible without entering any password. That means anyone can view VeryHidden data.

Is there any solution to this? Is it possible disable Save as (other format) option while normal save option remains active.

Hi there,

See if the following code does what you need - it should be inserted in the "ThisWorkbook" VBA CodeModule:

Please Login or Register  to view this content.

Note that this code should be inserted into a workbook which has already been saved at least once, otherwise the warning message will be displayed.


Hope this helps.

Regards,

Greg M

Thanks. Its working but when I open the file I'm getting Compatibility error (attached).

I think i figured out what is causing compatibility issue - The "Option Explicit" command. I've removed it and error is gone. This code is now working fine. Save As option is disabled.
BTW this code was working before as well, only that annoying compatibility msg was appearing every time i open the file.
Thanks all for your help.

Hi again,

Many thanks for your feedback - much appreciated!

You're welcome - glad I was able to help.

Regards,

Greg M