Adding the Properties Icon to the Standard Toolbar

Follow by Email
Facebook
Facebook
Google+
http://www.exceltip.com/excel-customizing/adding-the-properties-icon-to-the-standard-toolbar.html
SHARE




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.
Screenshot // Adding the Properties Icon to the Standard Toolbar
Adding the Properties Icon to the Standard Toolbar

Please follow and like us:
0


Leave a Reply

Your email address will not be published. Required fields are marked *

To avoid automated spam,Please enter the value *

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>