CaptRon
07-19-2013, 05:13 PM
I'm brand new at this and could use a little guidance. Here's what I'm trying to do:
Disable the CUT option on the ribbon for one type of user and enable it for another.
I have two buttons on a start sheet for two different types of users that unhide certain sheets and enable options for each of them. In Excel 2003, I could use VBA to disable and enable menu buttons, but it looks like I'll need some XML code to disable/enable the buttons on the ribbon.
I downloaded the custom UI editor, found some code, and successfully applied it so that the CUT option on the ribbon is disabled. But it stays that way and I would like to be able to enable/disable based on who's driving, so to speak.
Possible? Any help is appreciated.
Ron
Disable the CUT option on the ribbon for one type of user and enable it for another.
I have two buttons on a start sheet for two different types of users that unhide certain sheets and enable options for each of them. In Excel 2003, I could use VBA to disable and enable menu buttons, but it looks like I'll need some XML code to disable/enable the buttons on the ribbon.
I downloaded the custom UI editor, found some code, and successfully applied it so that the CUT option on the ribbon is disabled. But it stays that way and I would like to be able to enable/disable based on who's driving, so to speak.
Possible? Any help is appreciated.
Ron