Hi,

I have a requirement to add some guidance notes in a spreadsheet that is used to run other reports. These are split into sections for the different reports. These are set to hide and unhide the rows of reports.

What works:
I have successfully embedded the objects (pdfs as icons), set the properties so that they resize and move with the rows they are in and have added code to hide (Selection.RowHeight = 0) and reopen (Rows("5:5").EntireRow.AutoFit) which work nicely. Until the file is closed.

What doesn't work:
When the file is reopened and I expand my rows again, the object icons are all squished up together and are only 1px high.

Any idea how I can get the icons to stay where I put them and expand with the rows? It seems to be a relatively common issue (people don't seem to use these that often), but I can't find a solution.

Many thanks in advance

Ben