ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   VBA and Excel 2007 (https://www.excelbanter.com/excel-programming/406007-vba-excel-2007-a.html)

Brad

VBA and Excel 2007
 
Is it true that you cannot use VBA to disable items on the Ribbon?
Specificially the EDIT-CLEAR items...

Ron de Bruin

VBA and Excel 2007
 
You must use XML

See
http://www.rondebruin.nl/ribbon.htm

In one of the examples (number 2) for the UI editor you can see how

--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"Brad" wrote in message ...
Is it true that you cannot use VBA to disable items on the Ribbon?
Specificially the EDIT-CLEAR items...


Brad

VBA and Excel 2007
 
Thank you

"Ron de Bruin" wrote:

You must use XML

See
http://www.rondebruin.nl/ribbon.htm

In one of the examples (number 2) for the UI editor you can see how

--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"Brad" wrote in message ...
Is it true that you cannot use VBA to disable items on the Ribbon?
Specificially the EDIT-CLEAR items...




All times are GMT +1. The time now is 12:31 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com