Logo 
Search:

MS Office Forum

Ask Question   UnAnswered
Home » Forum » MS Office       RSS Feeds

Enable hyperlink in protected sheet

  Asked By: Thomas    Date: Mar 18    Category: MS Office    Views: 4274
  

I am using Excel 2000,I have unlocked few cells (for which i have to
insert hyperlink) and protected the sheet. The problem is that if i
protect the sheet i can type the text but cannot insert hyperlink to it.

Share: 

 

5 Answers Found

 
Answer #1    Answered By: Adelmo Fischer     Answered On: Mar 18

I would advise you to record a macro.

It seems that even if specific cells are not protected  you may enter text but
not hyperlink.
I believe then that you should try to record a macro, unprotect the sheet,
insert the hyperlink, protect the sheet  back except for the specific cells that
you want to keep unprotected.
I have recorded such a macro and it works.

 
Answer #2    Answered By: Mansur Bashara     Answered On: Mar 18

i tried the following
code , but did not work

With ActiveSheet
.Unprotect Password:="aaa"
With .Range("N8")
.Locked = False
.DrawingObjects:= True, Contents:=True, Scenarios:=True,
AllowInsertingHyperlinks:=True
End With
.Protect Password:="aaa"
End With

Also i tried the following :

Worksheets("Sheet1").Unprotect password:="aaa"
Worksheets.DrawingObjects := True, Contents:=True, Scenarios :=True,
AllowInsertingHyperlinks :=True
Worksheets("Sheet1").Protect password:="aaa"

whatz problem with the code?

 
Answer #3    Answered By: Farah Khan     Answered On: Mar 18

It is not that it doesn't work - it doesn't compile. Please always provide in
your message whatever error information the compiler or Excel has given you.

Where did you get this code from? Go back and have another look. Or check the
help on the Protect method. These items you have the := and commas with are
parameters of a protect call, not individual statements.

The := and comma syntax is only legal in the parameter area of a subroutine or
function call.

 
Answer #4    Answered By: Eline Bakker     Answered On: Mar 18

>the code was in a subroutine, the error was : Run-time error '1004' :
Application-defined or Object-defined error.

> It is not that it doesn't work - it doesn't compile. Please always
provide in your message whatever error information the compiler or
Excel has given you.
>
> Where did you get this code from? Go back and have another look.
Or check the help on the Protect method. These items you have the :=
and commas with are parameters of a protect call, not individual
statements.

 
Answer #5    Answered By: Harriet Hughes     Answered On: Mar 18

This seems to work (at least in Excel 2003)

ActiveSheet.Protect DrawingObjects:=True, _
Contents:=True, Scenarios:=True, _
AllowInsertingHyperlinks:=True

 
Didn't find what you were looking for? Find more on Enable hyperlink in protected sheet Or get search suggestion and latest updates.




Tagged: