Hi Ankit

However I have a doubt regarding your first solution. You mentioned
that validation doesn't work if the sheet has some other objects.

No

If you use the delete code that I posted it will delete the validation dropdowns in the sheet.
Then you can't use the dropdowns on that sheet anymore.

--
Regards Ron de Bruin
http://www.rondebruin.nl


"Ankit" wrote in message ups.com...
Ron,

I tried your solution and realised that the objects were hidden. So I
used ' ToolsOptionsObjectsShowAll ' to unhide them and this solution
worked.
However I have a doubt regarding your first solution. You mentioned
that validation doesn't work if the sheet has some other objects. I put
some objects from my side in that sheet and applied some validation.
Also I put the comment on the same cell.But the validation worked.

So I think the perfect solution to this problem was the one you
mentioned obove (unhide the objects).
Thanks for all your help.

Ankit
India