×

Passwords

Determining When An Excel Spreadsheet Is Protected

Determining When An Excel Spreadsheet Is Protected

Detecting Sheet Protection I can’t count how many times I have been completely confused while working in somebody else’s spreadsheet...

Password Protecting/Unprotecting A List of Excel Sheet Names

Password Protecting/Unprotecting A List of Excel Sheet Names

What This VBA Code Does Today, a colleague of mine described to me a situation (aka annoyance) he was trying...

Allow Groups to Expand/Collapse While Spreadsheet Is Password Protected

Allow Groups to Expand/Collapse While Spreadsheet Is Password Protected

What This VBA Code Does Unfortunately when password protecting your worksheets, there is no option to check that will enable...

VBA Function To Determine If Any Worksheet Tabs Are Protected

VBA Function To Determine If Any Worksheet Tabs Are Protected

What This VBA Code Does Excel does this annoying thing where it prevents you from creating custom Table or Slicer...

Insert & Delete Table Rows With Worksheet Protection

Insert & Delete Table Rows With Worksheet Protection

What This VBA Code Does When you check the "Insert Rows" option in the Protect Sheets dialog box, it only...

Masking (Hiding) A Password As It Is Entered In An Excel Text Box

Masking (Hiding) A Password As It Is Entered In An Excel Text Box

Today, I came across a spreadsheet that allowed a user to connect to a remote database via VBA. The spreadsheet...

How To Password Protect Opening An Excel File

How To Password Protect Opening An Excel File

Protecting Your Excel Files With A Password There are often files within an organization that need to be restricted from certain...

How To Determine If A Workbook or Worksheet Is Password Protected With Excel VBA

How To Determine If A Workbook or Worksheet Is Password Protected With Excel VBA

What This Does If you want to prevent errors from occurring when you macro code is running, it may be...

Setting The Proper Password Protection Using VBA Coding

Setting The Proper Password Protection Using VBA Coding

Prevent Destruction Many times I use worksheet protection to prevent my users from accidentally breaking formulas or disrupting formatting.  With...

The Various Ways To Password Protect Excel Worksheets

The Various Ways To Password Protect Excel Worksheets

Restricting Your User's Abilities Microsoft Excel's worksheet password protection options have been known to trip people up from time to...

Understanding Excel's Password Security Methodology

Understanding Excel's Password Security Methodology

How Secure is Excel? There is not a great deal of documentation out there about how Excel handles password security,...

The "Security Effect" - How To Create Partially Anonymous Data

There are definitely times when you are handling confidential data and want to make sure that data stays confidential.  This...

Protect Worksheet But Allow Formatting & Hiding Of Rows Or Columns

Protect Worksheet But Allow Formatting & Hiding Of Rows Or Columns

What This VBA Code Does This snippet of code will give you a couple of scenarios where you can protect...