gridlines

Try Tools-Options, then under view tab, uncheck gridlines.

Is this what you were looking for?

hi,

thanks for your reply. what i have is a macro that reads in a file, processes it then saves the processed sheets in a new workbook. i don't want the saved books to have any macros so i need to turn off the gridlines for them while running through my macros in the source sheet. this way, the gridlines are off on the new saved workbooks when they are opened but it is all done in the original sheet. i hope you can understand what i'm trying to say.

thanks,
steve

You could add the following:

ActiveWindow.DisplayGridlines = False

in your code before it saves to a new file.

: Try Tools-Options, then under view tab, uncheck gridlines. : Is this what you were looking for?