Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Delete contents of unprotected cells in workbook
Hi,
I have a workbook with half a dozen protected pages. Within each page is a range of unprotected cells. What I'm trying to do is write a macro which will delete the contents of all unprotected cells in the workbook. I've attempted writing this by selecting each of the unprotected cells in each page, then deleting. However, when I then assign the macro and run this, I get a runtime error because I am attempting to delete content from a protected sheet. Is there a simple way of doing what I want? Indeed, is there any way to do what I want, without unprotecting the workbook? Or, should I incorporate unprotecting and then reprotecting each sheet into the macro? I'd rather avoid this if I can? Many thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Locate and delete specific cells | Excel Discussion (Misc queries) | |||
Adding contents of cells by clicking in Excel 2002 | Excel Discussion (Misc queries) | |||
how can I duplicate or copy a workbook then divide selected cells. | Excel Discussion (Misc queries) | |||
how to update a shared workbook using the same cells at the same t | Excel Discussion (Misc queries) | |||
How do you delete one cell from a range of protected cells | Excel Worksheet Functions |