PDA

View Full Version : Turn CUT on and off



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

CaptRon
07-22-2013, 12:55 AM
Well, I think I have it figured out, thanks to forum posts by Andy Pope, Paul Hossler, and XLD as well as instruction found on the following sites:

Ron de Bruin - http://www.rondebruin.nl/win/s2/win013.htm

Greg Maxey - http://gregmaxey.mvps.org/word_tip_pages/customize_ribbon_main.html

MSDN - http://msdn.microsoft.com/en-us/library/office/aa338202(v=office.12).aspx#OfficeCustomizingRibbonUIforDevelopers_Dynamical ly

I'll try to attach a sample workbook to show what I pieced together. Hope others may benefit.

Ron

CaptRon
07-22-2013, 01:03 AM
For some reason, I am not able to add an attachment. Sorry.

Paul_Hossler
07-22-2013, 04:53 AM
I tried to post an example for you, and I can't insert [vba] tags, or an attachmentI figure VBAX is having server issues againIf you still are interesting in an example, PM me with an email addressPaulNot only that, the post is being wrapped with < p > tags

CaptRon
07-22-2013, 06:42 AM
Good morning Paul. I think I found what I needed to get the job done, but I would like to see an expert example as I'm sure my initial work, while marginally functional, could be improved. BTW, I found some examples you provided to others that helped me a lot. Thanks for responding and I will send a PM.

Paul_Hossler
07-22-2013, 07:02 AM
I would call it an 'Expert' example, but it seems to work ok :-)Paul

Paul_Hossler
07-22-2013, 02:31 PM
The N and the T make a lot of difference :-)I wouldn't call it an 'Expert' example, but it seems to work ok :-)Paul