| Home |
| Search |
| Today's Posts |
|
#8
Posted to microsoft.public.excel.programming
|
|||
|
|||
delete all but protected cells
Tested in XL 97 and XL 2002
Gord On Fri, 23 Jan 2004 10:42:14 -0800, Gord Dibben <gorddibbATshawDOTca wrote: King Macro works for me on a protected sheet. Hit CRTL + A to select all cells then run it. Clears the contents of all "unlocked" cells. Gord Dibben Excel MVP On Thu, 22 Jan 2004 21:24:08 -0600, Kingtriotn wrote: That clears the contents of all unlocked cells but only if the sheet is not protected. This is where I keep running into walls, why wont it clear the contents of the unlocked cells when the sheet is protected? Thanks again, Kingtriton --- Message posted from http://www.ExcelForum.com/ |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Protected sheet - attempt to delete row = unmerged cells | Excel Discussion (Misc queries) | |||
| Delete unprotected cells in protected worksheet | Excel Worksheet Functions | |||
| How do I delete only the content of cells that are NOT protected? | Excel Discussion (Misc queries) | |||
| How to delete the content of all unlocked cells in a protected she | Excel Discussion (Misc queries) | |||
| How do you delete one cell from a range of protected cells | Excel Worksheet Functions | |||
Threaded Mode
