VBA:Excel removing subtotal buttons 2

[RSJohnson]

I have to create a lot of budget spreadsheets with three levels of subtotals. The final products cannot have the buttons in the left margin that allow you to expand and contract levels. Is there a way to remove these buttons either with code or some other way?

 

[SkipVought]

semaphore,

Use Clear Outline

Data/Group & Outline/Clear Outline



Skip,

http://www.TheOfficeExperts.com

Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884

 

[TonyJollans]

Hi semaphore,

In your worksheet ..

Data > Group and Outline > Clear Outline

In code ..

[blue]Selection.ClearOutline[/blue]

Enjoy,
Tony

------------------------------------------------------------------------------------------------------
We want to help you; help us to do it by reading FAQ222-2244 before you ask a question.