Thread: On error
View Single Post
  #3  
Old April 19th, 2009, 02:25 PM posted to microsoft.public.excel.worksheet.functions
Jacob Skaria
external usenet poster
 
Posts: 5,952
Default On error

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