×

VBA Protection

Allow User-Specific Login Credentials To Be Pulled With Excel VBA

Allow User-Specific Login Credentials To Be Pulled With Excel VBA

There are a ton of great data programs out there that integrate very nicely with Excel. The problem I see...

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...

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...

VBA To Add A Confidentiality Footer Statement In Excel, Word, or PowerPoint

VBA To Add A Confidentiality Footer Statement In Excel, Word, or PowerPoint

What This VBA Code Does When handling sensitive data it is vital to display some sort of statement to let...

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...