-
Insert Hyperlink from External Source to a Protected Sheet
Hello! I have a worksheet with collection of pictures hyperlinked to an external folder. I need a VBA Code that enables me to “Insert - - > hyperlink” even if my worksheet is password protected. The worksheet was made for multiple users that is why some ranges need to stay protected while I insert my hyperlink. ‘ Insert à hyperlink’ option is greyed out in protected sheets. I tried using the code below but it did not fix my problem.
Private Sub Workbook_Open()
Sheet1.Protect Password:="password", DrawingObjects:=True, contents:=True, Scenarios:=True, userinterfaceonly:=True
Sheet1.EnableAutoFilter = True
Can someone help me out?
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules