edit certain hyperlink after a worksheet is protected
 

I have made a program to be able to log in with different login, and that
give you acces to different cells whitin the sheet. My problem is now how
just one person can get access to add?remove/edit a hyperlink. I have tried
to both unlock the sheet and the graphic object that the hyperlink is
conneted to, but nothing seems to work... Do i have to have the sheet
unprotected to be able to edit a hyperlink. I have excel 2000.

edit certain hyperlink after a worksheet is protected
 

In xl2000, I believe that would be true - you have to unprotect the sheet

--
Regards,
Tom Ogilvy

"Mia" wrote in message
...
I have made a program to be able to log in with different login, and that
give you acces to different cells whitin the sheet. My problem is now how
just one person can get access to add?remove/edit a hyperlink. I have
tried
to both unlock the sheet and the graphic object that the hyperlink is
conneted to, but nothing seems to work... Do i have to have the sheet
unprotected to be able to edit a hyperlink. I have excel 2000.

edit certain hyperlink after a worksheet is protected
 

Hi,

maybe i don't understand what you want exactly...
you can edit hyperlinks on a protected sheet from macro in excel 2000.
for instance,

Sub Test_EditHperlink()
Dim i As Integer

If ActiveSheet.ProtectContents Or _
ActiveSheet.ProtectDrawingObjects Then
ActiveSheet.Protect UserInterfaceOnly:=True
End If

For i = ActiveSheet.Hyperlinks.Count To 1 Step -1
With ActiveSheet.Hyperlinks(i)
Select Case .Type
Case msoHyperlinkRange
.Range.Select
Application.Dialogs(xlDialogInsertHyperlink).Show
Case msoHyperlinkShape
.Shape.Select
Application.Dialogs(xlDialogInsertHyperlink).Show
End Select
End With
Next
End Sub

--
HTH,

okaizawa


Mia wrote:
I have made a program to be able to log in with different login, and that
give you acces to different cells whitin the sheet. My problem is now how
just one person can get access to add?remove/edit a hyperlink. I have tried
to both unlock the sheet and the graphic object that the hyperlink is
conneted to, but nothing seems to work... Do i have to have the sheet
unprotected to be able to edit a hyperlink. I have excel 2000.

edit certain hyperlink after a worksheet is protected
 

My problem is now how
just one person can get access to add?remove/edit a hyperlink.


doesn't sound like that person will be writing code. Certainly the OP
could implement an interface of his/her own to accept the users input and
apply that to the hyperlink. (create, delete, edit)

--
Regards,
Tom Ogilvy


"okaizawa" wrote in message
...
Hi,

maybe i don't understand what you want exactly...
you can edit hyperlinks on a protected sheet from macro in excel 2000.
for instance,

Sub Test_EditHperlink()
Dim i As Integer

If ActiveSheet.ProtectContents Or _
ActiveSheet.ProtectDrawingObjects Then
ActiveSheet.Protect UserInterfaceOnly:=True
End If

For i = ActiveSheet.Hyperlinks.Count To 1 Step -1
With ActiveSheet.Hyperlinks(i)
Select Case .Type
Case msoHyperlinkRange
.Range.Select
Application.Dialogs(xlDialogInsertHyperlink).Show
Case msoHyperlinkShape
.Shape.Select
Application.Dialogs(xlDialogInsertHyperlink).Show
End Select
End With
Next
End Sub

--
HTH,

okaizawa


Mia wrote:
I have made a program to be able to log in with different login, and
that
give you acces to different cells whitin the sheet. My problem is now
how
just one person can get access to add?remove/edit a hyperlink. I have
tried
to both unlock the sheet and the graphic object that the hyperlink is
conneted to, but nothing seems to work... Do i have to have the sheet
unprotected to be able to edit a hyperlink. I have excel 2000.