XL7: xlNoButtonChanges Allows Toolbar Button Editing


In Microsoft Excel, when you change the property of a toolbar to
xlNoButtonChanges, you will still be able to change the image on a button
on that toolbar.


Microsoft Excel allows you to use a macro to set the properties of toolbars
to different levels of protection. The xlNoButtonChanges setting is
designed to keep a user from adding, removing, or moving toolbar buttons on
a toolbar. However, this property does not keep a user from editing the
toolface of the button.

Microsoft provides examples of Visual Basic procedures for illustration
only, without warranty either expressed or implied, including but not
limited to the implied warranties of merchantability and/or fitness for a
particular purpose. This Visual Basic procedure is provided 'as is' and
Microsoft does not guarantee that it can be used in all situations.
Microsoft does not support modifications of this procedure to suit customer
requirements for a particular purpose.

The following Visual Basic Code can be run to set the Standard toolbar to
   Sub ChangeToolbarProperties()     Toolbars("Standard").Protection = xlNoButtonChanges   End Sub
Setting the protection to xlNormal will reset the protection on the

ID članka: 134944 – Zadnji pregled: 14. feb. 2017 – Revizija: 1

Microsoft Excel 95 Standard Edition

Povratne informacije