Turn off all sheet gridlines without using ws.select?

Hello!

I don't like having the gridlines on when I use the workbook, but I do when creating. This code runs through the workbook and turns off all the gridlines (similar code for turning them on).

Anyway, it has a ws.select line to jump to each sheet. This makes the screen flicker all over the place, plus the cursor winds up somewhere else (another sheet) than the cursor started.

Can this code be made better to not use ws.select and still take care of all the sheets?

Please Login or Register  to view this content.

I appreciate the help!

Respectfully,

Lost

Maybe this will work

Please Login or Register  to view this content.

Or, you can add this to the beginning of your code:

Please Login or Register  to view this content.

and then this to the end

Please Login or Register  to view this content.

Doing it this way will remove the flickering. Use it wherever
you have .Select or .Activate within your code.

Try this

Please Login or Register  to view this content.

@RoyUK, Isn't it possible to do this without actually selecting the sheets?

By selecting the sheets it creates a Group, then changing the view on the active sheet the others grouped are changed.

Originally Posted by Mordred

@RoyUK, Isn't it possible to do this without actually selecting the sheets?

No - this is one of those rare occasions where you have to select, because you are dealing with a property of the window rather than the sheet.

Depends if you want to remove gridlines from it. If not, then loop each sheet, if visible select it, then turn off gridlines.