I have a sheet (excel 2000) which is protected, but hyperlink has to
be inserted for few cells. i tried to different ways, but could not
get the result,

ActiveSheet.Unprotect password:="a", DrawingObjects:=True,
contents:=True, Scenarios:=True, AllowInsertingHyperlinks:=True
ActiveSheet.Protect password:="a", DrawingObjects:=True,
contents:=True, Scenarios:=True, AllowInsertingHyperlinks:=True

i get the error as : Run time error '1004' 'Applicatiion defined or
object defined error'

can anyone help me with the code to :unprotect the sheet, insert
hyperlink to some cells and then protect the sheet in excel 2000