M
Mifty
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/com...&p=1&tid=68e31259-dee5-4fe2-a608-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
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/com...&p=1&tid=68e31259-dee5-4fe2-a608-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