hi guys,
Basically, I have an Excel 2003 file with some VBA code which I want protected. I used the VBAProjectProperties Dialog to set a password restricting viewing of the code. However, if the file is open in LibreOffice Calc then the protected VBA code is perfectly visible.
Some details: I have protected the workbook structure with a password. However, in the VBA code I hide and show certain sheets as appropriate, using the Visible property of the sheet. It cannot be edited though unless the workbook is unprotected. So for this reason before making the necessary changes I have to unprotect the workbook, make the changes and then protect the workbook again. To do so I have the password written in the VBA code.
Is there any way to prevent seeing the protected VBA code in Libre Office Calc?
Bookmarks