+ Reply to Thread
Results 1 to 3 of 3

Group Shapes and resize whole group

  1. #1
    Registered User
    Join Date
    08-21-2018
    Location
    Germany
    MS-Off Ver
    MS Office 2016
    Posts
    24

    Group Shapes and resize whole group

    Hi guys,

    i copied shapes in Excel and insert them in a PowerPoint-Slide. Next i grouped the inserted Shapes on the Slide.
    Now i want to resize the whole Group of shapes on my slide like Group.width = 200 or sth like that.

    Dim s As Shape
    Dim r As Range

    For Each s In Sheet7.Shapes
    If Not Intersect(Range("A1:S44"), s.TopLeftCell) Is Nothing Then 'B9:I25
    's.Delete 'Copy and Paste in PowerPoint
    s.Select Replace:=False
    End If
    Next s
    Selection.Copy

    PPslide.Shapes.PasteSpecial

    'Adjust the positioning of the Shapes on Powerpoint Slide
    PPslide.Shapes.SelectAll
    ppApp.ActiveWindow.Selection.ShapeRange.Group 'know the shapes on the PowerPoint-Slide are grouped

    --> Here i Need some Code from you, please

  2. #2
    Forum Guru
    Join Date
    07-25-2011
    Location
    Florida
    MS-Off Ver
    Excel 2003
    Posts
    9,643

    Re: Group Shapes and resize whole group

    Please Login or Register  to view this content.
    Surround your VBA code with CODE tags e.g.;
    [CODE]your VBA code here[/CODE]
    The # button in the forum editor will apply CODE tags around your selected text.

  3. #3
    Registered User
    Join Date
    08-21-2018
    Location
    Germany
    MS-Off Ver
    MS Office 2016
    Posts
    24

    Re: Group Shapes and resize whole group

    Thanks AlphaFrog. It worked out.
    Great :D

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Replies: 14
    Last Post: 01-12-2017, 01:41 PM
  2. excel 2013 customize context shapes and shapes group menu right click
    By Giuseppe77 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 12-03-2016, 11:50 AM
  3. excel 2013 customize context shapes and shapes group menu right click
    By Giuseppe77 in forum Hello..Introduce yourself
    Replies: 1
    Last Post: 12-03-2016, 11:50 AM
  4. Replies: 1
    Last Post: 02-10-2014, 10:26 PM
  5. [SOLVED] Group Shapes
    By zplugger in forum Excel General
    Replies: 3
    Last Post: 04-03-2013, 11:12 AM
  6. [SOLVED] Group Shapes with VBA
    By nicotob in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-17-2012, 05:12 AM
  7. Group and Name Shapes - How
    By barryleajo in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-04-2010, 07:32 AM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1