» Adding the Properties Icon to the Standard Toolbar
CATEGORY - Excel Customizing
VERSION - All Microsoft Excel Versions
Why add the Properties icon to the Standard toolbar?By setting the Scroll Area range, you restrict the accessible area in the sheet.
By changing the Enable Selection option, you choose one of three different sheet movement options when the sheet is protected.
By selecting XlSheetVeryHidden from the Visible dropdown list, you prevent the sheet from appearing in the hidden sheets list when selecting Sheet and then Unhide from the Format menu.
To add the Properties icon to the Standard toolbar:
1. Place the mouse pointer over one of the toolbars, right-click, and select Customize from the shortcut menu.
2. Select the Commands tab.
3. From Categories, select Control Toolbar and from the Commands box, drag the Properties icon to the Standard toolbar.
4. Close the Customize dialog box.

Book Store:
Recommended Books:
- The Complete Book of Business Plans: Simple Steps to Writing a Powerful Business Plan (Small Business Sourcebooks)
- Monte Carlo Methods in Finance
- Now, Discover Your Strengths
- Fish! A Remarkable Way to Boost Morale and Improve Results
- Keys to Reading an Annual Report (Barron's Business Keys)
- Real Estate Loopholes: Secrets of Successful Real Estate Investing
No comments have been submitted.

