Hiding rows with Object

Good Morning All,

I'm wondering if someone can help me with the attached sheet i have created. I am looking to hide rows on the "Specification" Sheet when column 'E' shows "N".

By doing this i also need Excel to hide the linked Word Document Object in each row.

To have column "E" change to "Y" the 'Quantity' in Column "D" on the "Site Survey" sheet needs to be changed to 1 or greater.

The sheet is used as a template so there is no reason to un-hide the cells, however it would be beneficial if possible.

Please note that i have removed a lot of the objects from the "Specification" sheet due to document size reduction, the file is available here due to the attachments failing to upload.

https://ufile.io/hpwbq

if anyone can help it will be greatly appreciated.

Many thanks,

Please upload your file directly to this site. Many of our members here are reluctant to open other locations that are unknown to them for fear of virus'. Click on the Go Advanced Button in the quick reply window. Scroll down to Manage Attachments and upload your file.

There is a size limitation. Is your file greater than the limitation?

Hi Craig,

If you must cross-post please provide a link to the site(s) as I have done with this link.

Robert

Moderator Comment: @Craigness-- Please read this: https://www.excelguru.ca/content.php?184