Hi Zeeshan,
You can enable outlining on protected sheets by use of some simple VBA code.
There is a protection option available only via VBA called
"UserInterfaceOnly". It's purpose is to allow other VBA code to maipulate
protected sheets freely, but have the sheets otherwise stay fully protected
for user actions. (It does not work 100% in all situations even for that
advertised purpose, by the way).
If we enable "UserInterfaceOnly" protection for the file, and then toggle
the VBA SHEET.EnableOutlining property to True, the sheet will be protected
with outlining enabled.
The UserInterfaceOnly protection option is not saved with the file, though,
so we have to take these steps every time the file is opened.
To do so, you can use the foloowing code in the ThisWorkbook module:
Private Sub Workbook_Open()
With Me.Worksheets("your_sheet_name")
.Protect Password:="your_password", UserInterfaceOnly:=True
.EnableOutlining = True
End With
End Sub
If you don't have/want a password, change the .Protect line to:
.Protect UserInterfaceOnly:=True
You can find some more details at
http://www.ozgrid.com/Excel/outlining-protected.htm.
Asa
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Zeeshan
Sent: Tuesday, December 04, 2012 9:03 PM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ How to make Outline work in Protection
Dear Mates,
I have been following this group for almost 3 years, and had been silent
spectator, picking up tips which has really helped me, but today i have to
post this query which i have been trying hard but could not find a solution.
Pl find attached file, this is grouped from Dates to Week and if i protect
the sheet then Outline does not work.
Waiting for Suggestions
regards,
Zeeshan
--
Join official Facebook page of this forum @
https://www.facebook.com/discussexcel
FORUM RULES
1) Use concise, accurate thread titles. Poor thread titles, like Please
Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will
not get quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security
measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.
NOTE : Don't ever post confidential data in a workbook. Forum owners and
members are not responsible for any loss.
---
You received this message because you are subscribed to the Google Groups
"MS EXCEL AND VBA MACROS" group.
To post to this group, send email to excel-macros@googlegroups.com.
To unsubscribe from this group, send email to
excel-macros+unsubscr...@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros?hl=en.
--
Join official Facebook page of this forum @
https://www.facebook.com/discussexcel
FORUM RULES
1) Use concise, accurate thread titles. Poor thread titles, like Please Help,
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.
NOTE : Don't ever post confidential data in a workbook. Forum owners and
members are not responsible for any loss.
---
You received this message because you are subscribed to the Google Groups "MS
EXCEL AND VBA MACROS" group.
To post to this group, send email to excel-macros@googlegroups.com.
To unsubscribe from this group, send email to
excel-macros+unsubscr...@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros?hl=en.
