Data Val Reset Does Not Work With Sheet Protection
 

Hi everyone,

I'm not sure about protocols for reposting so apologies if I've got it wrong
- I've posted to original post too.
http://www.microsoft.com/office/comm...8-22622a8dadc8

I've got a routine that should clear all data validation by putting ="" in
the cell ("" is one of my data val list)

It's been working fine and then stopped - possibly since I added protection
to all of the sheets. I've used the following macro to add user interface
only protection and though that this would allow routine to run

Sub ProtectUserInterfaceonlyAllSheets()
'protects user interface ALL worksheets

For Each Shts In ThisWorkbook.Worksheets

Shts.Protect Password:="", UserInterFaceOnly:=True

Next
End Sub

Any help would be appreciated greatly
Thank you
--
Mifty