Hi Rossoff,
Thx for the tip, i have tried this before but it did not worked.
not to disappoint you, however the purpose of protection is to hide
Formula's.
regards,
Zeeshan
On Thu, Dec 6, 2012 at 9:33 AM, Asa Rossoff <a...@lovetour.info> wrote:
> *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.
>
>
>
--
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.
