MrExcel's Learn Excel #593 - Unprotect Green Cells

Today, the questioner asks how to unprotect the green cells. There isnt any good way to do this in the Excel user interface, so in Episode 593, I use a tiny bit of VBA code to achieve the effect.

The code used in the podcast is:


Sub UnProtectGreen
For each Cell in Selection
If Cell.Interior.ColorIndex = 4 then Cell.Locked = False
Else Cell.Locked = True
End If
Next Cell
End Sub

This blog is the video podcast companion to the book, Learn Excel from MrExcel. Download a new two minute video every workday to learn one of the 277 tips from the book!

Category:

People & Blogs

Tags:

• Excel
• business
• accounting
• spreadsheets
• tutorial
• technology
• MrExcel
• VBA