Nov 06 2021 07:25 PM
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
Nov 07 2021 04:44 AM
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
Nov 07 2021 05:33 AM
"Lock cells to protect them" -> https://support.microsoft.com/en-us/office/lock-cells-to-protect-them-cb7835f6-9c37-4161-bb53-d1c410...
"Protect a workbook" -> https://support.microsoft.com/en-us/office/protect-a-workbook-7e365a4d-3e89-4616-84ca-1931257c1517
"What is encryption, and how does it work in Office 365?" -> https://docs.microsoft.com/en-us/microsoft-365/compliance/encryption?view=o365-worldwide#what-is-enc...
3rd-party encryption software: https://www.gpg4win.org/features.html
Latest version at this point in time ( gpg4win-3.1.16.exe ) -> https://files.gpg4win.org/
Nov 07 2021 07:41 AM - edited Nov 08 2021 12:48 AM
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/
Nov 07 2021 07:52 AM - edited Nov 08 2021 12:52 AM
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