How do I delete only the content of cells that are NOT protected?

D

DrDisk7

In a selected range of a partial or whole worksheet, is there a way to clear
the content of the cells which are selected but are NOT protected (or not
marked as "locked" in an unprotected sheet) while keeping all formats and
locked/protected cells in that range untouched. -- Is there a way to disable
the protection error so that the delete/clear command can go and do its job
on the unprotected cells? Even the earliest spreadsheets had it! Is Excel too
restricted?
 
G

Gord Dibben

Sub UnlockedCells()
Dim cl As Range
For Each cl In ActiveSheet.UsedRange
If cl.Locked = False Then
cl.ClearContents
End If
Next
End Sub


Gord Dibben MS Excel MVP
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Can't move between cells. (Not the scroll lock) 1
How to delete the content of all unlocked cells in a protected she 1
Protected sheet - attempt to delete row = unmerged cells 5
MS Excel 2003 - Autofilter for protected cells 1
Protect cells but allow for user input. 3
Hyperlinks in cells in a protected worksheet not working 5
How do I delete the contents of unprotected cells only? 3
How to permit editing the contents of added row(cells) if previous row is protected? 1

Top