Excel unprotect workbook and worksheets using VBA
I inherited some Excel spreadsheets which had protected workbooks and worksheets, but an unprotected VBA project. I didn’t have the passwords for the Excel spreadsheets. …
Excel Populate a Combo Box from a Database
To populate a combo box on a userform in Excel you need to use VBA. Firstly add a combo box to a userform in the …
Remove a line feed / carriage return from a string
This article describes how to remove the carriage returns and line feeds in SQL, Tableau, Excel and Access. If you ever have to deal with …