I am trying to create a menu using shapes, pictures and VBA.

I am inserting 10 shapes into an empty sheet, change the shape's text, insert and crop multiple icons/pictures, group and assign a macro to the grouped shapes.

I would like to create a dynamic menu that knows which sheet it is on and shows the corresponding shapes/menu items.

Is there a good way to do this? Perhaps create the shapes earlier and just position them?

Is there a way to store images in the worksheet using VBA?