Welcome toExcel.Tips.Net
Tips.Net Home
ExcelTips Home
Ask an Excel Question
Make a Comment
ExcelTips FAQ
ExcelTips Premium
Beauty Tips
Car Tips
Cleaning Tips
College Tips
Cooking Tips
Excel2007 Tips
ExcelTips
Family Tips
Gardening Tips
Health Tips
Home Tips
Money Tips
Organizing Tips
Pest Tips
Pet Tips
Wedding Tips
Word2007 Tips
WordTips
Advertise on the
ExcelTips Site
Assigning a Macro to a Keyboard Combination
Hiding Rows Based on a Cell Value
Subscriber Daniel Geiger complained that when he opens a workbook, the Reviewing and Web toolbars open automatically. He finds this bothersome, as he never uses these toolbars and must continually close them.
This behavior seems to be unique to Excel 2002. The Reviewing toolbar is supposed to start popping up when someone sends the workbook file via File | Send To | Mail Recipient (for Review). However, it is possible that this "feature" could get turned on at other times, as well. Basically, the setting means that whenever anyone opens the workbook, the toolbar pops into view, in an effort for Excel to be helpful.
The solution is to convince Excel that the workbook has not been sent via e-mail for someone to review. Follow these steps:
ExcelTips is your source for cost-effective Microsoft Excel training. This tip (2728) applies to Microsoft Excel versions: 97 2000 2002 2003
Got the Time? Understanding the ins and outs of working with times and dates can be confusing. Remove the confusion--ExcelTips: Times and Dates is an invaluable resource for learning how best to work with times and dates.