PC Review


Reply
Thread Tools Rate Thread

how to allow insert hyperlink and grouping together under protecti

 
 
rita wang
Guest
Posts: n/a
 
      13th Mar 2008
I tried to allow insert hyperlink and grouping together on a protected sheet,
I have tried to find seperate code to allow either of them, but when I tried
to put them together, it seemed really difficult.

THIS IS THE CODE TO ALLOW GROUPING/OUTLINING AND AUTOFILTER ON A PROTECTED
SHEET, AND THE PASSWORD IS SET AS EXCEL:

Private Sub Workbook_Open()
With Sheet32
..Protect Password:="EXCEL", UserInterfaceOnly:=True
.EnableOutlining = True
.EnableAutoFilter = True
End With
End Sub

AS BLOW IS MY ANSWER FROM HELP OF EXCEL TO ALLOW INSERTHYPERLINK ON A
PROTECTED SHEET,I have moved the part to mention just one single cell to
insert, because I want 3 whole column be inserted:
Sub ProtectionOptions()
If ActiveSheet.Protection.AllowInsertingHyperlinks = False Then
ActiveSheet.Protect AllowInsertingHyperlinks:=True
End If

MsgBox "Hyperlinks can be inserted on this protected worksheet."

End Sub


The point is when I put them together, the sheet can be inserted hyperlink,
grouping, protected,BUT the password doesn't work,the protection is very easy
to unprotect, just go to the data-protection-unprotected sheet.I have to
confess I never have experience of EXCEL PROGRAMMING, so could any maser help
me?

Thank you very much.

 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
How 2 do expand/collapse Groupped Columns after worksheet protecti ToMMie Microsoft Excel Misc 1 11th Sep 2008 03:37 AM
Insert Hyperlink: wrong hyperlink in outlook web access =?Utf-8?B?UGF0cmlrIEx1Y2E=?= Microsoft Outlook Discussion 1 14th Jul 2007 12:11 AM
Can't insert file into a contact using Insert as Hyperlink =?Utf-8?B?R0RDcm9zcw==?= Microsoft Outlook Discussion 0 12th Oct 2006 08:38 PM
Set target frame in hyperlink created by insert hyperlink ctrl =?Utf-8?B?QmlnU2t5MTgy?= Microsoft Powerpoint 1 31st Aug 2006 10:49 PM
Remove users from the Exceptions list when using document protecti =?Utf-8?B?S2ltYm9S?= Microsoft Word Document Management 3 26th Apr 2005 10:22 AM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 07:05 AM.