Hi guys,

Not sure if someone can assist me with the below.

I have 5 images which are located in Sheet 1 in the range F5 to H8. With each image I have assigned a macro and everything seems to work fine. Moreover I have set the properties to 'don't move or size with cells' for each image.

the only problem I have is with one of the macros whose function is to clear advanced filters:

Sub Clear_Filter_Leave()

Sheets("Leave_Data").Unprotect password:="k"

    If ActiveSheet.FilterMode Then
    ActiveSheet.ShowAllData

Sheets("Leave_Data").Protect password:="k"

End If
End Sub
Problem

Every time I run this macro it is resizing all the 5 images and moving them around even though I have set the properties of each image to 'don't move or resize with cells'.

Is there a possible solution to stop the images from being moved around and resized when this macro is executed?

Thanks a lot for all your help guys!!

Keibri