Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I delete only the content of cells that are NOT protected?
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? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I delete only the content of cells that are NOT protected?
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 On Fri, 16 May 2008 20:39:00 -0700, DrDisk7 wrote: 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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how to delete part of the content on multiple cells in excel? | Excel Discussion (Misc queries) | |||
How to delete the content of all unlocked cells in a protected she | Excel Discussion (Misc queries) | |||
DELETE CONTENT ADVISOR??? | Setting up and Configuration of Excel | |||
how to delete duplicated content from 2 cells | Excel Worksheet Functions | |||
How do you delete one cell from a range of protected cells | Excel Worksheet Functions |