Excel Titan

Knowledge should be shared freely, not hoarded.

Function To Test If The Workbook Is Protected

less than 1 minute read

Function to test if the workbook is protected.

less than 1 minute read

Function to tests if the active sheet is protected.

less than 1 minute read

Tests if any sheets in the active workbook are protected with or without a password.

1 minute read

Function to test an entire column or row has been selected.

1 minute read

User Defined Function to get the unique count in a range.