Business Solutions Tricks of the Microsoft Office 2007 Gurus

6. Workbook and Worksheet Tricks

IN THIS CHAPTER

Applying Text or Formatting to Multiple Worksheets

Annotating a Worksheet with Comments

Removing All Comments from a Workbook

Keeping Track of Worksheet Changes

Sharing a Workbook with Other Users

Preventing Users from Changing Parts of a Worksheet

Adding a Live Stock Price Quote to a Worksheet

Automatically Sorting a Range After Data Entry

Transposing Range Rows and Columns

Automatically Opening a Workbook at Startup

Creating a Workspace of Workbooks

Creating a Workbook with a Specified Number of Sheets

Selecting A1 on All Worksheets

Selecting the “Home Cell” on All Worksheets

Selecting the Named Range that Contains the Active Cell

Saving All Open Workbooks

Using Dialog Box Controls to Input ...