+ Reply to Thread
Results 1 to 7 of 7

VBA code, password-protected in Excel, visible in LibreOffice Calc

  1. #1
    Registered User
    Join Date
    01-29-2010
    Location
    Sofia, Bulgaria
    MS-Off Ver
    Excel XP, Excel 2003, Excel 2007
    Posts
    27

    VBA code, password-protected in Excel, visible in LibreOffice Calc

    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?

    Boris

  2. #2
    Forum Guru JosephP's Avatar
    Join Date
    03-27-2012
    Location
    Ut
    MS-Off Ver
    2003/10
    Posts
    7,328

    Re: VBA code, password-protected in Excel, visible in LibreOffice Calc

    not as far as I know. vba project protection is weak
    Josie

    if at first you don't succeed try doing it the way your wife told you to

  3. #3
    Registered User
    Join Date
    01-29-2010
    Location
    Sofia, Bulgaria
    MS-Off Ver
    Excel XP, Excel 2003, Excel 2007
    Posts
    27

    Re: VBA code, password-protected in Excel, visible in LibreOffice Calc

    Hi Josie,
    Thanks for the reply.
    Is there anything else I can do in this situation?

  4. #4
    Forum Guru JosephP's Avatar
    Join Date
    03-27-2012
    Location
    Ut
    MS-Off Ver
    2003/10
    Posts
    7,328

    Re: VBA code, password-protected in Excel, visible in LibreOffice Calc

    not really-worksheet/workbook protection prior to 2013 is also very weak and easily broken due to the way it's stored so if someone is determined to unprotect the workbook/worksheets you won't be able to stop them-unless you want to try one of the programs that compiles workbooks into an executable file

  5. #5
    Registered User
    Join Date
    01-29-2010
    Location
    Sofia, Bulgaria
    MS-Off Ver
    Excel XP, Excel 2003, Excel 2007
    Posts
    27

    Re: VBA code, password-protected in Excel, visible in LibreOffice Calc

    Thanks again. At least I have an answer now.
    Last edited by bstoyano; 07-18-2013 at 04:07 AM.

  6. #6
    Forum Guru JosephP's Avatar
    Join Date
    03-27-2012
    Location
    Ut
    MS-Off Ver
    2003/10
    Posts
    7,328

    Re: VBA code, password-protected in Excel, visible in LibreOffice Calc

    if you're only worried about them being able to easily read the worksheet password you could write an encryption/decryption function to at least mask the password in the code, but you still won't have any real security

  7. #7
    Registered User
    Join Date
    01-29-2010
    Location
    Sofia, Bulgaria
    MS-Off Ver
    Excel XP, Excel 2003, Excel 2007
    Posts
    27

    Re: VBA code, password-protected in Excel, visible in LibreOffice Calc

    Well, I have no idea how to do such a function. Besides, if someone has enough knowledge as to reach so far, I guess he/she will be skillful enough to reverse the calculations of such a function. So, I will just leave it all as is.
    I did this VBA code only to help both sides in the process - save data entry and ease (semi-)automatic processing. I doubt that someone will put much effort as to break what has been done. At least if any, my guess is that they will be less than a dozen. This is perfectly acceptable.
    Thanks again for your guidance and advices.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Asks for password for protected VBA code when closing Excel
    By SpringLily in forum Excel Programming / VBA / Macros
    Replies: 18
    Last Post: 05-28-2016, 12:18 PM
  2. Libreoffice: Use data in Base for calculations in Calc. Possible?
    By vivace in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 05-14-2013, 08:04 AM
  3. Replies: 5
    Last Post: 09-20-2005, 02:05 PM
  4. Replies: 0
    Last Post: 09-06-2005, 04:05 AM
  5. Replies: 0
    Last Post: 09-06-2005, 12:05 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1