Removing the Sub-Total Levels

  • Thread starter Thread starter MikeM
  • Start date Start date
M

MikeM

Is there a way to remove the Numbered Levels that apear on the left of the
Row and Column Headings? I want to keep the Sub-Totals but do not want to
show the "Drill Downs" + and/or - options 1 2 3... What would the command in
the Macro be to hide these?
 
In xl2003 menus:

Tools|Options|View|uncheck Outlining symbols.

If you need a macro, you can record one when you do it manually.
 
Why did I not see that! THANKS!
--
MJM


Dave Peterson said:
In xl2003 menus:

Tools|Options|View|uncheck Outlining symbols.

If you need a macro, you can record one when you do it manually.
Click to expand...
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Sub-total using Advanced Filter? 4
VBA set thick borders around non empty cells in range 0
Modify Claus code "Sub Array_Var_Column_Sort()" 27
For-Next by a row Counting consecutive Zero in the column 4
Sub-total questions 5
Remove Hyperlinks Without Changing background shading 14
Sub Total 1
VBA userform Vlookup Excel 1

Back
Top