Raymond PENTIER
Posted messages58205Registration dateStatusContributorLast intervention17 475
Have you tried to: * right-click on Size and Properties/Properties/ * select "Don't move or size with cells", * protect the sheet? -- Retirement is nice! Especially in the Caribbean... :-) ? Raymond?
UP! Additionally, I am correcting a small mistake; I want to insert an image into an Excel sheet and have it fixed. Or find a way to ensure that it is always resized and properly placed.
By using VBA, I start by selecting a cell on the sheet where I want to insert my image. I insert my image, and then I resize it.
Worksheets("Feuil1").Range("A1").Select ActiveSheet.Pictures.Insert("address where the image is located").Select With Selection .Width = .Height = End With