Kashya, this time with the link.
http://www.excel-vba.com/vba-code-2-2-error.htm
If this post helps click Yes
---------------
Jacob Skaria
"Kashyap" wrote:
Hi, I have code as below which will update links..
On error sheet will be unlocked.. how to lock the sheet again and exit sub?
Sub ref()
ActiveSheet.Unprotect Password:="abc"
ActiveWorkbook.UpdateLink Name:= _
"asdasd", _
Type:=xlExcelLinks
ActiveSheet.Protect Password:="abc"
End Sub