Logo 
Search:

MS Office Forum

Ask Question   UnAnswered
Home » Forum » MS Office       RSS Feeds

unprotect the sheet, insert hyperlink & then protect the sheet

  Asked By: Ricky    Date: Nov 13    Category: MS Office    Views: 1838
  

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

Share: 

 

1 Answer Found

 
Answer #1    Answered By: Kellie Bishop     Answered On: Nov 13

AFAIK Unprotect only has a single parameter - password.

 




Tagged: