Solved: 2007 Menus

[Ruckley]

Hi,

is it possible to disable some of the menu options (Developer, View, Review etc) on the 2007 ribbon?

I've realised that users will be able to see background pages in my application using Review/Next and I don't want them to be able to do it.

any help gratefully received.

: pray2:

[Jan Karel Pieterse]

Have a look at http://www.rondebruin.nl/ribbon.htm

[Ruckley]

Yeah done it, but now it no longer works in v2003. Its a pain.
Thanks though.

[Bob Phillips]

You don't have a ribbon with 2003!

[Ruckley]

No, what I meant was, to disable the menu's in 2007, it needs to be saved as a .xlms file rather than .xls. Which then doesn't work in 2003.

[Bob Phillips]

I have two files, a 2003 file which does the work, and if opened in 2003 it does my menu bits, else it opens a new specific 2007 file.

Have you tried conditional compilation?

[Ruckley]

I have no idea what that means. I was going to produce 2 versions of the same workbook.

[Bob Phillips]

ARe you disabling the 2007 ribbon tabs via code or in the XML? If the former, we should be able to run that from an xlks. If the latter, we need the two files, but the 2007 version is very light.