RE: $$Excel-Macros$$ How to make Outline work in Protection
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.
Re: $$Excel-Macros$$ How to make Outline work in Protection
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
RE: $$Excel-Macros$$ How to make Outline work in Protection
Hi Zeeshan, I have used this method myself--it's always worked for me. Have you tried it this time? If you have trouble, just repost your file and I will look at it to see what the problem is. Asa From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of ZeeSHAN Sent: Wednesday, December 05, 2012 11:12 PM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ How to make Outline work in Protection 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 mailto:excel-macros%2bunsubscr...@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
Re: $$Excel-Macros$$ How to make Outline work in Protection
Hi Anoop, that was easy, however if you click on + of the outline, that does not work when the sheet is protected. This is the problem and i need to make that work with your help. regards, Zeeshan On Wed, Dec 5, 2012 at 10:47 AM, Anoop K Sharma aks.sharm...@gmail.comwrote: Hi Zeeshan, Please find attached. Regards, Anoop Sr. Developer On Wed, Dec 5, 2012 at 10:33 AM, Zeeshan zeesha...@gmail.com wrote: 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. -- Regards, Anoop Sr. Developer -- 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.
