Adding the Properties Icon to the Standard Toolbar

 

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



Leave a Reply

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

*

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>