how to protect sheet

%3CLINGO-SUB%20id%3D%22lingo-sub-2935015%22%20slang%3D%22en-US%22%3Ehow%20to%20protect%20sheet%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2935015%22%20slang%3D%22en-US%22%3E%3CP%3EHi%2C%20I%20have%20created%2035%20identical%20worksheet%20for%20my%20workbook.%20there%20are%20some%20identical%20cells%20that%20I%20need%20to%20lock.%20is%20there%20an%20easy%20way%20to%20protect%20all%20sheets%20in%20the%20workbook%20in%20one%20go%20rather%20than%20protect%20sheets%20one%20at%20a%20time.%3F%20Thanks%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2935015%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2935953%22%20slang%3D%22en-US%22%3ERe%3A%20how%20to%20protect%20sheet%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2935953%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F228076%22%20target%3D%22_blank%22%3E%40govind%20patel%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EYou%20could%20run%20a%20macro%20like%20this%3A%3C%2FP%3E%0A%3CPRE%20class%3D%22lia-code-sample%20language-visual-basic%22%3E%3CCODE%3ESub%20ProtectSheets()%0A%20%20%20%20Dim%20w%20As%20Worksheet%0A%20%20%20%20For%20Each%20w%20In%20Worksheets%0A%20%20%20%20%20%20%20%20w.Protect%20Password%3A%3D%22topsecret%22%0A%20%20%20%20Next%20w%0AEnd%20Sub%3C%2FCODE%3E%3C%2FPRE%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2936022%22%20slang%3D%22en-US%22%3ERe%3A%20how%20to%20protect%20sheet%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2936022%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F228076%22%20target%3D%22_blank%22%3E%40govind%20patel%3C%2FA%3E%3C%2FP%3E%3CP%3E%22Lock%20cells%20to%20protect%20them%22%20-%26gt%3B%20%3CA%20href%3D%22https%3A%2F%2Fsupport.microsoft.com%2Fen-us%2Foffice%2Flock-cells-to-protect-them-cb7835f6-9c37-4161-bb53-d1c410acaf21%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3Ehttps%3A%2F%2Fsupport.microsoft.com%2Fen-us%2Foffice%2Flock-cells-to-protect-them-cb7835f6-9c37-4161-bb53-d1c410acaf21%3C%2FA%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%22Protect%20a%20workbook%22%20-%26gt%3B%20%3CA%20href%3D%22https%3A%2F%2Fsupport.microsoft.com%2Fen-us%2Foffice%2Fprotect-a-workbook-7e365a4d-3e89-4616-84ca-1931257c1517%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3Ehttps%3A%2F%2Fsupport.microsoft.com%2Fen-us%2Foffice%2Fprotect-a-workbook-7e365a4d-3e89-4616-84ca-1931257c1517%3C%2FA%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%22What%20is%20encryption%2C%20and%20how%20does%20it%20work%20in%20Office%20365%3F%22%20-%26gt%3B%20%3CA%20href%3D%22https%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Fmicrosoft-365%2Fcompliance%2Fencryption%3Fview%3Do365-worldwide%23what-is-encryption-and-how-does-it-work-in-office-365%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3Ehttps%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Fmicrosoft-365%2Fcompliance%2Fencryption%3Fview%3Do365-worldwide%23what-is-encryption-and-how-does-it-work-in-office-365%3C%2FA%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E3rd-party%20encryption%20software%3A%20%3CA%20href%3D%22https%3A%2F%2Fwww.gpg4win.org%2Ffeatures.html%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fwww.gpg4win.org%2Ffeatures.html%3C%2FA%3E%3C%2FP%3E%3CP%3ELatest%20version%20at%20this%20point%20in%20time%20(%20%3CA%20href%3D%22https%3A%2F%2Ffiles.gpg4win.org%2Fgpg4win-3.1.16.exe%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%22%3Egpg4win-3.1.16.exe%3C%2FA%3E%20)%20-%26gt%3B%20%3CA%20href%3D%22https%3A%2F%2Ffiles.gpg4win.org%2F%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Ffiles.gpg4win.org%2F%3C%2FA%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

Hi, I have created 35 identical worksheet for my workbook. there are some identical cells that I need to lock. is there an easy way to protect all sheets in the workbook in one go rather than protect sheets one at a time.? Thanks

5 Replies

@govind patel 

You could run a macro like this:

Sub ProtectSheets()
    Dim w As Worksheet
    For Each w In Worksheets
        w.Protect Password:="topsecret"
    Next w
End Sub

@govind patel

Part1: More 3rd-party tools to protect proprietary information in Windows / Office 365 ->

 

"How to Protect Your Digital Systems from the Quantum Apocalypse" -> https://www.electronicdesign.com/industrial-automation/article/21167611/sectigo-how-to-protect-your-...

 

VeraCrypt: Portable version for Windows 8 and later: https://www.veracrypt.fr/en/Downloads.html

1.) Favorites -> Add Mounted Volume to System Favorites / Organize System Favorites

2.) Global Settings -> Enable "Mount system favorite volumes when Windows starts (in the initial phase of the startup procedure)"

3.) Global Settings -> Enable "Allow only administrators to view and dismount system favorite volumes in veracrypt"

4.) Settings -> Performance / Driver Configuration -> Enable "Accelerate AES Encryption/decryption"

5.) Settings -> Performance / Driver Configuration -> Enable "Use CPU hardware random generator as an additional source of entropy"

6.) Settings -> Performance / Driver Configuration -> Enable "Activate encryption of keys and passwords stored in RAM"

7.) Settings -> Performance / Driver Configuration -> Enable "Enable extended disk control codes support"

 

"Zero Trust Architecture" -> https://csrc.nist.gov/publications/detail/sp/800-207/final

 

Security Keys:

https://www.yubico.com/solutions/zero-trust/

https://store.google.com/us/product/titan_security_key?hl=en-US

 

"SDelete implements the Department of Defense clearing and sanitizing standard DOD 5220.22-M, to give you confidence that once deleted with SDelete, your file data is gone forever." -> https://docs.microsoft.com/en-us/sysinternals/downloads/sdelete

 

"Checklist Repository" -> https://ncp.nist.gov/repository?product=Microsoft+Windows+Server+2019&sortBy=modifiedDate%7Cdesc

"STIG Viewer 2.x" -> https://public.cyber.mil/stigs/srg-stig-tools/

"NIST Special Publications" -> https://csrc.nist.gov/publications/sp

"X9’s Quantum Computing Information Page" -> https://x9.org/quantum-computing/

 

@govind patel

Part2: More 3rd-party tools to protect proprietary information in Windows / Office 365 ->

 

VeraCrypt 1.24-Update7 User Guide CHM -> https://launchpad.net/veracrypt/trunk/1.24-update7/+download/VeraCrypt%20User%20Guide.chm

 

Can be opened with this: https://www.sumatrapdfreader.org/download-free-pdf-viewer

Or this: https://mupdf.com/downloads/index.html

 

System Encryption -> (PAGE: 9 - VeraCrypt User Guide.chm)

Cascades of Ciphers -> (PAGE: 38 - VeraCrypt User Guide.chm)

Keyfiles -> (PAGE: 25, 87 - VeraCrypt User Guide.chm)

 

Keyfile: 32768 x 256-bit = 1MB (2097152 hex chars)

 

D. E. Knuth. The Art of Computer Programming, Volume 2: Seminumerical Algorithms. ->
https://docs.microsoft.com/en-us/dotnet/api/system.random?view=net-5.0#remarks

 

Note: When you add these other drives as system favorites, they will obviously only mount if they have the same password as the system drive (they also won't show up in the volume manager, even though they are already mounted.) Typically you can boot into WinPE and use the portable version (once you install it to your USB drive.) You can use that to backup the volume headers into a separate folder, and even keep all your restore disks in zip format on a single drive (even going in to create restore disks out of the USB drive, so you don't have to have the bootloader stored on the drive itself, if that's actually a real concern.)

 

rufus-2.18.exe / rufus-2.18p.exe -> https://rufus.ie/downloads/

 

Default Rescue disk (USB drive) -> GPT partition scheme for UEFI -> FAT32 (Default) -> Cluster size: 4096 (Default) -> Enable "Quick Format" Checkbox -> Set the label to whatever you want -> Click the Start button

 

"WinPE: Store or split images to deploy Windows using a single USB drive" -> https://docs.microsoft.com/en-us/windows-hardware/manufacture/desktop/winpe--use-a-single-usb-key-fo...

 

"You can use UWF to make read-only media appear to the OS as a writable volume." -> https://docs.microsoft.com/en-us/windows-hardware/customize/enterprise/unified-write-filter

 

"Boot to a virtual hard disk: Add a VHDX or VHD to the boot menu" -> https://docs.microsoft.com/en-us/windows-hardware/manufacture/desktop/boot-to-vhd--native-boot--add-...

 

Perfectly sized disk drives using Binary Prefixes (NTFS / FAT32) ->

 

1TB = 1048576 (MB) -> 2^20 * 1

500GB = 512001 (MB) -> 500 * 1024 + 1

250GB = 256001 (MB) -> 250 * 1024 + 1

150GB = 153601 (MB) -> 150 * 1024 + 1

100GB = 102401 (MB) -> 100 * 1024 + 1

50GB = 51201 (MB) -> 50 * 1024 + 1

NTFS -> (Size in GB * 1024) + 1

FAT32 (up to 32GB) -> (Size in GB * 1024) + 12

 

Perfectly sized disk drives using Binary Prefixes (Unix/Linux) ->

 

NEWFS: TB = {[(1099511627776 * Size in TB) + 1048576] / 512}

NEWFS: GB = {[(1073741824 * Size in GB) + 1048576] / 512}

FDISK EXAMPLES:

1TB = 16385 cylinders {[(2^40) / (Cylinder Blocks * Sectors)]+1}

500GB = 8001 cylinders {[(2^30 * 500) / (Cylinder Blocks * Sector Size)]+1}

250GB = 4001 cylinders {[(2^30 * 250) / (Cylinder Blocks * Sector Size)]+1}

150GB = 2401 cylinders {[(2^30 * 150) / (Cylinder Blocks * Sector Size)]+1}

100GB = 1601 cylinders {[(2^30 * 100) / (Cylinder Blocks * Sector Size)]+1}

50GB = 801 cylinders {[(2^30 * 50) / (Cylinder Blocks * Sector Size)]+1}

 

"Prefixes for binary multiples" -> https://physics.nist.gov/cuu/Units/binary.html

 

thank you all it is a great help to me, appreciated.