Removing GRIDLINES from one sheet to another sheet without activating the sheet using VBA

Hi I know how to remove the Gridlines from the Active Sheet and also manually by going in the View Gridlines - Uncheck however, I am now pasting the data from one sheet to another and I want to actually do two things if possible..

1. Copy the Gridline Condition from the Parent Sheet to the Value Sheet , like the if the Parent SHeet has no gridlines if it has no GRIDLINES then the Child or the Copied Sheet should also not have any GRIDLINES.

2. Simply put no GRIDLINES command when pasting the data in the CHILD sheet using a MACRO.

Warm Regards
e4excel