S
Shawn
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
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