Forum Discussion

Cinzia Romagnoli's avatar
Cinzia Romagnoli
Copper Contributor
Jun 06, 2018

Set default setting when grouping pinctures

Hi everyone,

 

I'm new here :)

I have a problem, I work a lot with pictures grouped with text, shapes and other pictures. Every time cancel a column/row or resize it, it automatically resizes the group of pics. So first of all when I'm done grouping I have to  go to the format picture and select "move but don't size with cells". the problem is that if after that I add another item to the group, the setting is canceled I have to re-set it again. And this happens for all the groups in one worksheet and in all the worksheets, in every file. I spend more time on that than on the work itself. So the question is: is there a way to set my preference once for all?

 

Thank you!!

excel

1 Reply

Sort By
  • Matt Mickle's avatar
    Matt Mickle
    Bronze Contributor
    Jun 06, 2018

    Hey Cinzia-

     

    Welcome to the Excel Community.  I don't think this option exists.  However, you can use this short code snippet to change the setting for all pictures on your worksheet at once when you are done editing the groups:

     

    If you are unfamiliar how to use this code, you can take a look at this website for a tutorial:

    http://www.contextures.com/xlvba01.html

     

     

    Sub FloatFix()
    Dim s As Shape
    For Each s In ActiveSheet.Shapes
        s.Placement = xlFreeFloating
    Next s
End Sub

     

     

     

Resources