Workspace and Gridlines

[FP&A Queen]

I have a workspace which opens 50 workbooks. Each was saved without gridlines.

When I open the workspace the gridlines appear. I can toggle off on each one with button, but it is annoying me.

Also, the view % goes back to 100%.

Any suggestions would be appreciated

 

[santeria]

Um, Whats your question

 

[TryingToLearn]

I beleive the questions are:

1. How to turn off gridlines when the workspace is opened

may be out of my league here, but would try:

Private Sub Workbook_Activate()
    Dim c As Window
    Dim ws As Worksheet
    For Each c In ThisWorkbook.Windows
        For Each ws In ThisWorkbook.Worksheets
            c.DisplayGridlines = False
        Next ws
    Next c
End Sub

2. how to keep the view as it was when the workspace was saved

No ideas here on this one!

 

[santeria]

Okey-Kokey:

Maybe this will help...

Gridlines no more

http://www.mrexcel.com/board2/viewtopic.php?t=43523&highlight=gridlines


Workspace

http://support.microsoft.com/default.aspx?scid=KB;en-us;160264&

Courtesy of Nate in reply discussion
http://www.mrexcel.com/board2/viewtopic.php?t=60313&highlight=workspace