Gregg Wolin
So far it is a challenge ...
New Window would use default settings, which could modify with
Excel has the ability to use a custom template for all new workbooks. If you find yourself making the same changes to new workbooks (changing row height, font size, zoom, etc.) a default custom template can save you time and trouble.
exceljet.net
... but only Excel knows, could those gridlines set off
... without feature, which You want to avoid.
Your original question was:
Can someone please tell me the best way to do this and where to put the code?
If above do not solve Your challenge and
the code ... would mean VBA ( which You try to avoid )
then one of the best way would be to solve Your challenge is
to do it manually ( uncheck that gridlines option ). Use it as normal routine procedure.