Password Protected Excel Macro Becomes Fully Visible in Open Office

[Rene Karolyi]

Hi!

I have invested a lot of time and considerable effort to compose and program a quite complex technical application for my customers. I have taken all necessary steps, to avoid the user and of cause competitors from looking behind the scenes by using some of the techniques I learned through this very forum and by password protecting the VBA code.
Now, quite by chance I discovered that, if my spreadsheet application is opened with Open Office the VBA code becomes exposed without Open Office even asking for the password to be supplied . Just like that. From this I understand, that MS Excel does not encrypt the VBA code at all. Quite a serious security flaw as I see it!
Is there something that can be done to avoid this issue to happen and that keeps the code invisible if the password is not supplied?
It is really crucial! I will very much appreciate any help from your side!
Thank you in advance
Rene

 

[Darwood]

No, but it is considerably more secure than VBA.

true, true!

 

[sabret00the]

In my case I have a lot of old vba macros with me which were created by employees who are no longer in the organisation. The modules are password protected so although I can see the the entire vba codes in Open Office but I'm unable to locate the actual password to unlock the modules in MS Excel.

Any help will be appreciated.

 

[RoryA]

I'm afraid it is against forum rules to assist with any sort of circumvention of security measures.

 

[oggi38]

hi,
i think that the only way is to make .xlam open-libre office cannot bypass its protection.