Get Business Solutions Tricks of the Microsoft Office 2007 Gurus now with O’Reilly online learning.
O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.
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 ...