Macro linking order of two objects with contents of Cell A1

[yorkshirelad]

I posted this earlier but didn't get a positive response - my challenge is much clearer now and I would appreciate any help.

I have two objects (box1 and box2) on top of each other on a worksheet. Each of these objects contain hotspots which run a different set of macros.

I would like a macro that would allow the order of the two objects to be determined by the contents of a cell on the worksheet.

For example if cell A1 = 1 then box1 is on top, If cell A1 = 2, then box2 is on top.

Many thanks

 

[Von Pookie]

Please continue in your original thread:
http://www.mrexcel.com/board2/viewtopic.php?t=126689