Remove gridline from single worksheet

*Edit* Thank you Leath and Jeff. I suspected it was not possible; my next question would have been about the grid color . Thanks again.


Hello.

I need to do the following:
-Add and name worksheet (works)
-Add object to worksheet from pc (works)
-Remove gridlines from new worksheet only (ActiveWindow command applies to all worksheets)

Below is the code I have tried. I commented each line. Do you have any suggestions?

Please Login or Register  to view this content.

Thank you for your time,
-Kurt

Hello Kurt,

The GridLines property applies only the Window object. Since the Window is responsible for displaying the worksheets, you won't be able to apply this to a single sheet. However, you can change the GridLine color on a worksheet. You can hide them by making the same color as your worksheet's background color.

Hi Leith,

It seems this worked for the active workbook or maybe I don't quite understand.

Please Login or Register  to view this content.

Hello Jeff and Kurt,

I should have provided an example. Here is a macro to hide the grid lines. It changes the borders to match the cell's color.

Please Login or Register  to view this content.

Thanks Leith,

I see it now...I was just turning off the DisplayGridlines; however, you are hiding it with a color all together.

Thank you for the direction.