Excel 2007 : Enabled outline in a worksheet protected

[jmaterano]

Hello How are you?

How do I do if I protect a sheet in a workbook but I want to outline enabled in a worksheet?

Thanks for your answers!

Best regards!

[davesexcel]

Can you not enable formats in the protection option?

[romperstomper]

You have to use code to set the EnableOutlining property of the sheet and then protect it with the Userinterfaceonly:=true option. Note that this has to be done each time you open the workbook - sample code:

Please Login or Register  to view this content.

[jmaterano]

Thank you very much for your answer, that's what I needed.

I have only one question, how I can do to apply to all sheets of a book?

Best regards from Venezuela.

Juan

[romperstomper]

You would need a loop:

Please Login or Register  to view this content.

and then call that sub from the Workbook_Open event or an Auto_Open routine.

[jmaterano]

Thanks a lot it works nice!

[romperstomper]

Glad to help.

If you are satisfied with the solution(s) provided, please mark your thread as Solved.

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save