Ask Your Question

LibreOffice shows the source code of password protected VB Project in MS Excel [closed]

asked 2014-06-30 09:32:14 +0200

this post is marked as community wiki

This post is a wiki. Anyone with karma >75 is welcome to improve it.

I have added macro code using VB to my excel file and have password protected the created VB Project. When I open the excel file in LibreOffice, I get a runtime error at the event of macro code execution, but that is not an issue. The main issue is that after the error, LibreOffice displays entire source code of my VB project (macro code), which is a major security leak in my application. Kindly help me resolve this issue.

edit retag flag offensive reopen merge delete

Closed for the following reason the question is answered, right answer was accepted by Alex Kemp
close date 2016-02-27 10:49:56.014324

3 Answers

Sort by » oldest newest most voted

answered 2014-06-30 11:32:08 +0200

Lupp gravatar image

Shouldn' it be the concern of MS to implement a password protection for contained VB code that withstands scaling about on the fly?

If LibreOffice can do that other applications will also be capable of.

edit flag offensive delete link more

answered 2014-06-30 15:14:01 +0200

bawldiggle gravatar image

I have written commercial Excel addins (in VBA) over the years. Engineering based.

I would be really annoyed if my intellectual property can be "cracked" by simply opening the the xla files in Libre Office. Currently my code is protected with a 48 character password, so far I have been unable to crack the password after 5 days (120 hours of scanning).

edit flag offensive delete link more


Somebody may be sceptical about the concept of "Intelectual Property". We won't resolve the issue here. But ... If MS think it was necessary offering password protection for embedded VBA code it was surely THEIR RESPONSIBILITY to implement it in a way inhibiting simply ignoring the protection. LibO will surely not have built in the ultimate code cracking engine. Something wrong with MS IntProp? Or was the protection inadvertently switched off before saving the document for reopening in LibO?

Lupp gravatar imageLupp ( 2014-06-30 16:45:13 +0200 )edit

Question Tools

1 follower


Asked: 2014-06-30 09:32:14 +0200

Seen: 1,633 times

Last updated: Jun 30 '14