MrExcel Publishing
Your One Stop for Excel Tips & Solutions

gridlines


Posted by steve on January 02, 2002 12:55 PM


hi,

i'd like to be able to turn off the gridlines in a workbook without using activewindow. is it possible to do this?

thanks


Posted by Scott on January 02, 2002 12:57 PM

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

Is this what you were looking for?

Posted by steve on January 02, 2002 1:08 PM


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


Posted by Scott on January 02, 2002 1:34 PM

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?