Make a Shape behave like a Toggle Button

Is there any way to programatically or otherwise, get a 'Shape' (Insert>Shape) to behave like an Active-X toggle button?

I want to run Excel in 'Full Screen' mode, i.e. without the ribbon, formula bar, outline, headings, status bar etc. I still want to be able to hide and unhide groups on the page, but I want to do this using a Shape, rather than a standard, Active X 'Toggle Button', so when clicked, the shape changes from Green with a '+' sign in it, to Red, with a minus sign in it, whilst simultaneously grouping and ungrouping a specified range of rows or columns.

Is there any way to achieve this?

Hi royUK,

I tried recording a macro, but that doesn't really seem to work. What I need is to be able to adapt this 'toggle buton' code for a 'shape'. instead on an Active X toggle button, but I'm not sure how to do that?

Please Login or Register  to view this content.

RoyUK,

Perfect, all working now...

Many thanks