-
Recent Posts
- Excel VBA: Empty Clipboard Excel
- How to Get a Full File Path in Excel?
- Remove Non-AlphaNumeric Characters from String
- Sum Unique/Distinct Values in Excel
- Excel Extract Cell Comments
- How to get an Acronym using Excel VBA?
- Get Position of Last Column Containing Data with Excel VBA
- Find the Last Day of any Month
- Schedules to Refresh Data Automatically using VBA Macro
- Excel VBA Add Set of Worksheets Automatically
Tag Archives: microsoft excel password
Automatically Protect/UnProtect All Worksheets
Tonight I want to automatically protect and unprotect all Microsoft Excel Worksheets in my Workbook with password, instead of doing it manually, I put these following Excel VBA macro code in my Workbook. Public Sub ProtectAllSheets() Dim objSheet As Worksheet … Continue reading