Thread: subtotal bold
View Single Post
  #9   Report Post  
Posted to microsoft.public.excel.programming
Bob Phillips Bob Phillips is offline
external usenet poster
 
Posts: 10,593
Default subtotal bold

First you need to have the Developer tab showing.

Click the big orange Office button, then the Excel Options button. Select
Popular from the left pane, and then check 'Show Developer tab in the
Ribbon'.

You then have access to record as in pre-2007 Excel in the Code group.

--
---
HTH

Bob


(there's no email, no snail mail, but somewhere should be gmail in my addy)



"Helmut" wrote in message
...
Hi dave,
Can you translate this to Excel2007?

"Dave Peterson" wrote:

Record a macro when you hide the details
Select the range you want bold
Edit|goto|special|visible cells onl
Format the selection to bold

And you'll have code that should work ok.

Helmut wrote:

How can I have the entire ROW in the subtotal routine BOLD?


--

Dave Peterson