RE: $$Excel-Macros$$ How to make Outline work in Protection

2012-12-05 Thread Asa Rossoff
lf 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 purpo

Re: $$Excel-Macros$$ How to make Outline work in Protection

2012-12-05 Thread ZeeSHAN
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 wrote: > *Hi Zeeshan,* > > You can enable outlining on protected sheets by

RE: $$Excel-Macros$$ How to make Outline work in Protection

2012-12-05 Thread Asa Rossoff
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 prote

Re: $$Excel-Macros$$ How to make Outline work in Protection

2012-12-04 Thread ZeeSHAN
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 wrote: > Hi Zeeshan, > > Please find attached.