Hi guys,

Just a real quick one, as I'm struggling to find any info through good ol' google...


I have two custom ribbons saved; 'ribbon1' and 'ribbon2'.

I also have a button on a form; 'myButton'.


Now, is there anyway to change the ribbon from 'ribbon1' to 'ribbon2', when 'myButton' is clicked...


Is that at all possible? If not, are there alternatives I can use to achieve similar results... Even just hiding it and showing it would be pretty useful. Not ideal, but useful.


Oh, obviously I'm looking for VBA code to achieve this. Forget to mention that!


Thanks all!