Join the Newsletter Product Help
Search
×
Excel VBA About Shop

Excel Protection

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

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