If you're replying to me, you need to select VIEW --> TOOLBARS --> Customize, from the Commands tab, select FORMS, in the window under Commands: scroll down until you see Toggle Grid. Select this with the mouse and drag it into one of the existing toolbars.
The Active Window only works for that sheet. I want to turn the gridlines off in specific tabs. For example I have 14 tabs and I want to write some VBA that when run turns off the gridlines in say 7 of them. Is this possible ?