encrypte excel file

liuwei@cesm 631 Reputation points
2021-02-24T17:32:21.25+00:00

HI, Expert,

Could you give help how to encrypte the file to prevent change on worksheet?

version Office 365

  1. try setup password protect sheet .
  2. setup password on VB command button. to prevent change on worksheet.

password up to 30 length with Letters, Mixed case, Punctuation,Numbers. ==== very strong.

I test decrypte the file by free tool. It will decrypte in one minute.

Tks n brgds
Liu Wei

0 comments No comments
{count} votes

Accepted answer
  1. Tom van Stiphout 1,696 Reputation points MVP
    2021-02-25T14:21:47.58+00:00

    That tells you it did not use Brute Force approach to decrypt.

    If you want NSA-level security, Excel is not your tool.
    If you want to keep honest people honest, the Sheet Protection feature is just fine.

    0 comments No comments

0 additional answers

Sort by: Most helpful