Hiding Rows and Objects - VBA / Macro

[CraigACE]

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,

 

[Trebor76]

Hi Craig,

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

Robert

 

[Fluff]

Cross posted https://www.excelforum.com/excel-programming-vba-macros/1266665-hiding-rows-with-object.html

While we do not prohibit Cross-Posting on this site, we do ask that you please mention you are doing so and provide links in each of the threads pointing to the other thread (see rule 13 here along with the explanation: Forum Rules).
This way, other members can see what has already been done in regards to a question, and do not waste time working on a question that may already be answered.