FinancialAnalystKid
Well-known Member
- Joined
- Oct 14, 2004
- Messages
- 779
I have this code to clear all the unprotected cells in a sheet. How can it be modified to select ALL sheets and clear all the unprotected cells?
Thanks for help!
Thanks for help!
Code:
Sub ClearUnprotectedCells_AZ500()
For Each c In Range("A1:AZ500")
If c.Locked = False Then c.ClearContents
Next
End Sub