Turn off all sheet gridlines without using ws.select?

[leaning]

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

[Mordred]

Maybe this will work

Please Login or Register  to view this content.

[mohd9876]

you can always turn off screen updating to disable the flickering:

Please Login or Register  to view this content.

[Mordred]

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.

[leaning]

Mordred,

I like your sheet counter idea.

I put your code behind a button, but it doesn't seem to be doing anything.

Am I missing something?

Respectfully,

Lost

[mohd9876]

Try this one:

Please Login or Register  to view this content.

[royUK]

Try this

Please Login or Register  to view this content.

[Mordred]

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

[royUK]

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

[romperstomper]

@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.

[leaning]

All,

Thanks for all the info! And I see some new stuff I can put in the original code that would make it better.

The reason I posted the question is because one of the workbooks has a hidden sheet.

When you run the Gridlines code, it fails with error 1004: WS Select Method. My first thought that maybe the code could be revised to not even do select, but from the discussion, it looks like that won't work.

So, is the best way for the code to handle that sheet is to temporarily unhide it (make it visible, select it, change gridlines, and then make it not visible)? Or is there a better way?

Respectfully,

Lost

[romperstomper]

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

[leaning]

All,

I appreciate everyone's help! This is the code I ended up with to run through the workbook and turn gridlines off on all visible/unhidden sheets:

Please Login or Register  to view this content.

Good stuff!

Thanks and props to everyone who came to my aid.

Respectfully,

Lost