Use only VBA to change ribbon Excel 2007

**tapapad** · 07-06-2009, 09:54 AM

Hello,

Is it possible to use just VBA code within a workbook to change the Excel 2007 ribbon?

In particular I want to remove the command "Allow users to edit ranges" from the Review tab.

thanks and best regards,
tasos

**romperstomper** · 07-06-2009, 10:10 AM

I don't believe so, no. You can hide the whole Ribbon, but I don't think you can disable individual controls without XML.

**tapapad** · 07-06-2009, 11:43 AM

hmm. that's bad news for me :-( are you 100% sure ??

**romperstomper** · 07-06-2009, 11:54 AM

I'm not 100% sure about my own existence.
I would say 99% sure, but I am occasionally wrong.

Use only VBA to change ribbon Excel 2007

LinkBack

Thread Tools

Rate This Thread

Display

Use only VBA to change ribbon Excel 2007

Re: Use only VBA to change ribbon Excel 2007

Re: Use only VBA to change ribbon Excel 2007

Re: Use only VBA to change ribbon Excel 2007

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions