Screenshots gets removed in googlsheets

The screenshot images in excel isn’t available on viewing the same file in google sheets.I get the below notification at the top.

The problem here is the screenshots are added via vbcode .When i paste screenshot manually and viewing the file in googlesheet shows the screenshot.

Can anybody help on this??

Unsupported named ranges will be removed google sheets

You have to look up what named ranges are in Google Sheets first. You may find this helpful: