Alexander Illarionov AlexanderPro

## MSEXCEL-SHEETPROTECTION.md

      
              1 file
            
          
              0 forks
            
          
                0 comments
              
            
              0 stars
            
          
                AlexanderPro
                / MSEXCEL-SHEETPROTECTION.md
            
            
              Created
              September 6, 2024 12:07
                — forked from LiEnby/MSEXCEL-SHEETPROTECTION.md
            
              
                Reverse Engineering; Microsoft Excel Sheet Protection
              
          
    Microsoft Excel offers a feature called "Sheet Protection"
it essentially allows you to lock down an excel document so you cannot edit certain sheets and aspects of it
attempting to edit protected sheets will return an error message:

and trying to unprotect it under the review tab, does ask for a password.

i figured; "This is MS Excel, surely someone has found a way to disable this?"

  
## Examples
#In Package Manager Console:
#1. Re-format all files of the selected project
#Format-Document
#2. Re-format all files of the whole solution
#Get-Project -All | Format-Document

# Print all project items
Recurse-Project -Action {param($item) "`"$($item.ProjectItem.Name)`" is a $($item.Type)" }

# Function to format all documents based on https://gist.github.com/984353
	#In Package Manager Console:
	#1. Re-format all files of the selected project
	#Format-Document
	#2. Re-format all files of the whole solution
	#Get-Project -All \| Format-Document

	# Print all project items
	Recurse-Project -Action {param($item) "`"$($item.ProjectItem.Name)`" is a $($item.Type)" }

	# Function to format all documents based on https://gist.github.com/984353