XL7: xlNoButtonChanges Allows Toolbar Button Editing

Last reviewed: September 13, 1996
Article ID: Q134944

The information in this article applies to:

Microsoft Excel for Windows 95, version 7.0

SUMMARY

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.

MORE INFORMATION

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 xlNoButtonChanges:

   Sub ChangeToolbarProperties()
     Toolbars("Standard").Protection = xlNoButtonChanges
   End Sub

Setting the protection to xlNormal will reset the protection on the toolbar.

KBCategory: kbenv
KBSubcategory: xlwin
Additional reference words: 7.00 toolface buttonface

THE INFORMATION PROVIDED IN THE MICROSOFT KNOWLEDGE BASE IS PROVIDED "AS IS" WITHOUT WARRANTY OF ANY KIND. MICROSOFT DISCLAIMS ALL WARRANTIES, EITHER EXPRESS OR IMPLIED, INCLUDING THE WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE. IN NO EVENT SHALL MICROSOFT CORPORATION OR ITS SUPPLIERS BE LIABLE FOR ANY DAMAGES WHATSOEVER INCLUDING DIRECT, INDIRECT, INCIDENTAL, CONSEQUENTIAL, LOSS OF BUSINESS PROFITS OR SPECIAL DAMAGES, EVEN IF MICROSOFT CORPORATION OR ITS SUPPLIERS HAVE BEEN ADVISED OF THE POSSIBILITY OF SUCH DAMAGES. SOME STATES DO NOT ALLOW THE EXCLUSION OR LIMITATION OF LIABILITY FOR CONSEQUENTIAL OR INCIDENTAL DAMAGES SO THE FOREGOING LIMITATION MAY NOT APPLY.

Last reviewed: September 13, 1996
© 1998 Microsoft Corporation. All rights reserved. Terms of Use.