+ Post New Thread
Results 1 to 3 of 3
Office Software Thread, Password protecting spreadsheets with macros in Technical; Hi, I have a spreadsheet in .xlsb format which is protected with 'password to open' to which I want to ...
  1. #1

    Join Date
    Apr 2013
    Posts
    2
    Thank Post
    0
    Thanked 1 Time in 1 Post
    Rep Power
    0

    Password protecting spreadsheets with macros

    Hi,

    I have a spreadsheet in .xlsb format which is protected with 'password to open' to which I want to add a Excel 4.0 macro worksheet.

    I know that I can save it as .xls and add the macro sheet, however, I am unsure if this will compromise the level of encryption provided.

    Searching the internet I can't find a definitive answer as to whether the level of encryption is linked to the version of Excel used to save the file, or the document format used.

    Please could someone advise me as to whether saving as a .xls will lead to the file becoming no longer secure.

    Thanks,
    Vin

  2. #2

    Join Date
    Apr 2013
    Posts
    2
    Thank Post
    0
    Thanked 1 Time in 1 Post
    Rep Power
    0
    Answer to my own question

    Plan cryptography and encryption settings for Office 2013

    "If you have to encrypt Office documents, we recommend that you save the documents as Open XML Format files (.docx, .xlsx, .pptx, and so on) instead of Office 97–2003 format (.doc, .xls, .ppt, and so on). The encryption that is used for binary documents (.doc, .xls, .ppt) uses RC4. It isn’t recommended, as discussed in Security Considerations sections 4.3.2 and 4.3.3 of the Office Document Cryptography Structure Specification. Documents that are saved in the older Office binary formats can only be encrypted by using RC4 to maintain compatibility with older versions of Office. AES, the default and recommended encryption algorithm, is used to encrypt Open XML Format files."

    Though this does still leave me wondering how I am to save documents securely with macros, but I suppose the answer is simply that I am not.

  3. Thanks to schoolDataManager from:

    LosOjos (24th April 2013)

  4. #3

    LosOjos's Avatar
    Join Date
    Dec 2009
    Location
    West Midlands
    Posts
    5,447
    Thank Post
    1,438
    Thanked 1,168 Times in 797 Posts
    Rep Power
    707
    Quote Originally Posted by schoolDataManager View Post
    Though this does still leave me wondering how I am to save documents securely with macros, but I suppose the answer is simply that I am not.
    Thanks for sharing

    I would assume from that info that saving as XLSB would be the most secure as that is part of the newer Open XML format and so should use AES encryption

SHARE:
+ Post New Thread

Similar Threads

  1. Open password protected access 2007 database with ASP
    By ryan_powell in forum Web Development
    Replies: 0
    Last Post: 31st January 2008, 02:52 PM
  2. Password Protected Hard Drive
    By StewartKnight in forum Hardware
    Replies: 19
    Last Post: 6th November 2007, 10:51 AM
  3. Password Protect Internet
    By binky in forum Wireless Networks
    Replies: 1
    Last Post: 30th August 2007, 03:36 PM
  4. Password Protect USB Key
    By sqdge in forum Windows
    Replies: 2
    Last Post: 31st July 2007, 03:47 PM
  5. password protect exe for free
    By Uraken in forum Windows
    Replies: 15
    Last Post: 21st February 2007, 12:42 PM

Thread Information

Users Browsing this Thread

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

Tags for this Thread

Posting Permissions

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