Forum Discussion

marhen's avatar
marhen
Copper Contributor
May 07, 2020

Problem using embeded pictures in Excel 2016

Hi, 

when I am using in Excel Embeded pictures there is a bug which i didn't understand, sometimes everything works fine and sometimes the embeded pictures have a wrong zoom. 

 

In this picture  you see the wrong zoom you see that when you look at "Vorbunkeranlage" and compare it with the second picture

here you can see the correct zooming.  So when you open this workbook 10 times you have 3 times correct zoom and 7 times the wrong zoom

Have you got ideas why sometimes this is happening or a work arround to solve this problem?

Best Wishes Marc

 

 

excel

2 Replies

    • marhen's avatar
      marhen
      Copper Contributor
      May 08, 2020

      Hi Jan,

      yes, i am using a small code to copy an Image to the sheet onklick

       

      Sub EskalationLinks()
'
' EskalationLinks Makro
    Dim sheetName As String
    Dim Pfeilname As String
    
    DimPfeilname = "TcardOrange"
    
    
    sheetName = Application.ActiveSheet.Name
    Sheets("Pfeile").Select
    ActiveSheet.Shapes.Range(Array(DimPfeilname)).Select
    Selection.Copy
    Sheets(sheetName).Select
    Range("A1").Select
    ActiveSheet.Paste
End Sub

       

      JKPieterse 

Resources