Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Data Validation Lost After Clearing All Shapes
I'm trying to delete all shapes on a sheet which works using the below code,
but a problem I'm having is that any validation list on the same sheet is also deleted, and once delete validation lists will NOT appear on that same sheet again even after restarting excel. Does anyone know how to either clear all shapes but NOT validation lists, or have any knowledge about why this occurs and why you then can't add a new validation list (If I goto data validation the list settings are correct and reference the list named range - doing the same on another tab works correctly). For Each oShape In Sheets("Sheet1").Shapes oShape.Delete Next oShape |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Deleting shapes with VB deletes cell validation as well. EH? | Excel Programming | |||
Used drawing colors in shapes....lost default colors for "Fill Col | Excel Discussion (Misc queries) | |||
I have lost the in cell drop down in validation | Excel Worksheet Functions | |||
Validation lost on advanced filter copy | Excel Programming | |||
Excel VBA - Clearing Shapes and Cell Contents | Excel Programming |