(Unresolved Bugs) Remove VBA password prompt after quit Excel

I never experienced Remove VBA password after quit Excel. Seems like a strange behavior

Originally Posted by Faridwahidi

Is there any better workaround to overcome the issue? Please help me.

I explored this problem very thoroughly. And I did find one workaround that works (it's not a perfect solution though). See my thread: http://www.excelforum.com/excel-prog...to-appear.html

Hi Faridwahidi, so did converting your macro workbook to a XLA/XLAM add-in fix the problem for you?

PS Thanks for the rep

Hello Faridwahidi,

This has been a long standing problem as you have discovered. Excel's protection has always been about preventing accidental changes to data or formulas. It was never designed to provide real security.

Over the years, some software companies have created Excel compilers to provide security. These programs are applications that convert an Excel workbook into an executable file to protect data and prevent viewing.

While this conversion process does encrypt the data to prevent viewing and changes, it is not without it's drawbacks. Once encrypted, some common problems are you can not enter new formulas, insert or delete rows, sort data, use array formulas, or add new sheets.

Other drawbacks affect deployment like compatibility between versions of Excel, language differences, 32 and 64 bit architectures, and Window OS versions. Also, needed run-time files must to installed on the client's machine for the workbook to perform correctly.

Compiling large files with lots of formulas or extensive VBA code have been shown to problematic. Freezing, crashing, and data loss or corruption are not uncommon problems. However, in my research I did find a company who has taken a different approach to Excel file security. I have not used this program and don't know if it lives up to it's claims. You may want to check it out for yourself DataSafeXL.

Hi Leith Ross,

Thanks for very clear and helpful explanation.
I would rather decide not to use password and advise my users not editing the code.


@mc84excel,
Thanks for your feedback too.