The Incredible Shrinking Sentence

The Cannonball Run (1981)
He's my shrink. He was committed yesterday. 

If you have a block of code with long lines that you quote in a document, the long lines can wrap around to the next line which looks really bad and makes the code harder to understand.  To fix this problem, we start with a macro found over at WordTips and add a conditional statement so that it only is executed for a certain style (in this case Code Box). The macro reduces the font by ChangeSize and then checks if the paragraph fits on one line. It then repeats this process until it fits on one line.

Sub forceParaOneLine()
    Dim objPara As Paragraph
    Const ChangeSize = 0.5
   
    For Each objPara In ActiveDocument.Paragraphs
        If objPara.Style = ActiveDocument.Styles("Code Box") Then
            With objPara.Range
                While .Information(

wdFirstCharacterLineNumber) <> .Characters(Len(.Text)).Information(wdFirstCharacterLineNumber)
                    .Font.Size = .Font.Size - ChangeSize
                Wend
            End With
        End If
    Next objPara
               
End Sub

Note that if you have really long lines, this will reduce the font so that it is impossible to read.  To avoid this, I suggest using 2 styles in your document: one for code that can be shrunk, and one that is not shrunk.

[source WordTips]

Gmail: Going Label Crazy

Marion: [laughs] What is this stuff, Rene?
Belloq: [laughing as well] I grew up on this. It's my family label.  

This morning I noticed that you can apply custom colors to labels in Gmail. I have used labels in the past, but the labels didn't really stand out which reduced their usefulness.  With custom labels you can easily differentiate all the emails in your Inbox (work emails in one color, mailing list emails in another color, etc.)

Here's how to use the custom colors. First, create labels and filers.

1. Create a label. See instructions from Google Help.
2. Create a filter to apply the label. See instructions from Google Help.

Now we need to apply custom colors to the labels. Click the little arrow next to the label that you want to change:

 When you click the arrow, you get a popup window like this one:

The color choices were a little too dark for my taste.  When I tried them, it was hard to see the text next to them because of the contrast.  You can click on Add custom color and choose a background and text color.

Now all your labels look just the way that you want them.

Happy labeling :)

Selecting a Text Block

I just came across the shortcut of the year for MS Word over at TechRepublic.  Normally, when selecting text, you select it in a continuous line.  You can expand the selection forwards or backwards.

But, did you know that you can select a text block?  This is one of the powerful features of Vim for those of you who have used Unix computers.

Just hold the ALT key while you click.

For example, if I have the following text:

REM First  line

REM Second line

REM Third  line

You can hold the ALT key and then select the first three letters of each sentence:

REM First  line

REM Second line

REM Third  line

You can also cut and paste a block of text. In the above example, one could cut the selection and then paste it in the middle of the first line, resulting in:

 First REM line

 SecondREM line

 Third REM line

Note that selection of text blocks does not work inside of tables.

[Source TechRepublic]

Word: TOC Switches

The Princess Bride (1987)
You only think I guessed wrong! That's what's so funny! I switched glasses when your back was turned! Ha ha! You fool! You fell victim to one of the classic blunders - The most famous of which is "never get involved in a land war in Asia" - but only slightly less well-known is this: "Never go against a Sicilian when death is on the line"! Ha ha ha ha ha ha ha! Ha ha ha ha ha ha ha! Ha ha ha... 

Switches are what you use when building a TOC in Word to make it do what you want it to do. For example, { TOC \c "tables" } will make a TOC based on a sequence field identifier.

Here are some basic field command shortcuts:

• ALT+F9 show/hide all field codes
• Shift+F9 show/hide current field code
• Ctrl+F9 insert an empty field
• Ctrl+a, then F9 updates all fields in the document

The following lists all the available switches (taken from the Microsoft site, see links at the bottom).

Too Much Style

Police Officer: You in the red Corvette! Pull over immediately.
Xander Cage: Yeah, yeah. These monkeys are following me because I just took this car. Obviously the car doesn't belong to me, it's not my style...

If you are overwhelmed by the number of styles in Word 2007, you can configure Word to show only the styles that are currently being used in the document:

1. Alt + Ctrl + Shift + s  (opens the style box)
2. Click on Options on the bottom right
3. Under Select styles to show choose In use

Now, in the panel on the right you only see what is currently being used in the document.  The ribbon at the top still gives you access to all the styles.  If you apply a style that is not currently being used, then it gets added to the panel on right.

You can also use Ctrl + Shift + s to pop up a window where you can type in a style name. This window has auto complete, so just start typing and the closest match to the style name will fill in.

Power to the Point

Have you ever sat through an awful presentation? I think that we all have. Too many slides. Too little time.

"Good morning class.  Today we have to move a little fast.  We've got 1 hour and 60 slides, so no questions until the end."

Or, there's the presenter who crams his whole presentation into the slides.

"Um, excuse me... are you just going to read each slide to me?  It seems like your not adding anything, so can I just have a copy of the slides and I'll go back to work?"

Here is a nice rule of thumb for Powerpoint presentations (from this blog):

It’s quite simple: a PowerPoint presentation should have ten slides, last no more than twenty minutes, and contain no font smaller than thirty points.

 

He calls it the 10/20/30 rule.  Sounds good to me.

[Source: Guy Kawasaki]