Images in Excel

[Wallpag]

I hope someone can help me with this, I have been trying to do this for days!

I have a front page that links to a second worksheet that contains 140 images, these 140 are in 8 categorises. What I would like to do is to organise these images into 8 sections within the worksheet that you can then use a scrollbar to scroll along the images. You can then link from the 1st front page back to the images on the second worksheet.

So my question is does anyone know how to organise images, I have tried using the control toolbox, ImageListControl and a few more, but nothing seems to work as I want it. I have also tried inserting some scrollbars but I have not been able to achieve what I am after.

Can anyone point me in the right direction, or just give me an idea of the best way of presenting (and linking) to a number of pictures in excel.

Thanks for your help!

 

[Sektor]

As images are members of Shapes collection, we can use Shape object to work with image.

Sub ArrangeShapes()

    Dim shp As Shape, cell As Range
    
    Set cell = Range("A1")
    
    For Each shp In Sheet1.Shapes
        shp.Left = cell.Left
        Set cell = cell.Offset(5, 0)
    Next

End Sub

 

[Wallpag]

I am new to using macro, so how would I use that code?