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
The applications/code on this site are distributed as is and without warranties or liability. In no event shall the owner of the copyrights, or the authors of the applications/code be liable for any loss of profit, any problems or any damage resulting from the use or evaluation of the applications/code.