I have just started looking at playing around with the ribbon in VBA, and have learned enough that it is a blooming nightmare.
I am scaling down my plans. I think that I would be satisfied with minimising the ribbon. To do this I think I either need to:
1) Read the registry to see the current ribbon state and conditionally use Send Keys to minimise the ribbon if it is currently maximised (yuck)
2) Download some tool from MS, read a heck of a lot of documentation, create some XML and paste it into the document XML (double yuck)
Are these basically my options? Is there something much simpler I am missing?
Forgot to mention (in fact the ramifications have only just struck me now) that this would be run in 2003 compatibility mode. As such, I had late binding in mind but of course when it comes to the XML I'm stuffed.
Option 3 doesn't cut it either - I want to minimise not remove.
Thanks for your help - you've confirmed what I thought
It does seem very odd that the ribbon isn't just exposed by the object model. On the whole I still find the ribbon a real barrier as a user, and this is after a year of using 2007. Annoying to find it is even worse from the perspective of a developer!