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 ...
excel
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