I wrote a quite simple macro to use a png picture as a grid for Excel. It worked fine with Excel 2007, but now I switched to Excel 2013 and a small problem emerged:

Despite the fact, that the macro works, the png picture is displayed in another size on my second PC. The zoom is 100%, the setup of both PCs is identical. However, if the picture is displayed in different sizes it makes the grid worthless.

Has anyone any ideas? I want the grid picture always with the same size if the zoom equals 100%...

This is my code and it worked perfect with Excel 2007:

Sub MyGrid()
ActiveSheet.SetBackgroundPicture Filename:=""

ActiveSheet.SetBackgroundPicture Filename:= _
"C:\mygrid\MyGrid.PNG"
End Sub

Thanks!