Thursday, November 10, 2016

Word Changing Styles

Changing Styles in Word 2007  mid sentence

Easy way to change styles is to right click on Quick access tool bar
and select customize quick access toolbar





Select all commands and add style separator to Quick Access Tool bar

When you want to change style just click and select the style you want to change to





























Tuesday, November 8, 2016

Listing Tab names in Excel

To list tabs in an Excel spread sheet use VBA





Sub ListSheetNames()
Dim R As Range
Dim WS As Worksheet
Set R = ActiveCell
For Each WS In ThisWorkbook.Worksheets
R.Value = WS.Name
Set R = R(2, 1)
     Next WS
End Sub