Exel 2003

[Randall]

Hi All i am back i have got my form set up in exel i know wish to use it but
i do not need the the rest of the exel grid i just need the form that i have
made up to send to my agents so that they can fill in the info that is needed
i need them to be able to save the form on the desktop and then email a copy
each week whith the info for that week.

 

[JLatham]

Tools | Options then select the [View] tab. Clear the checkbox next to
"Gridlines"

That may leave you with no lines at all - and if you need some in the form
area, then you'll need to add them as Borders to the cells.

Alternatively you can simply hide the unused rows and columns, this macro
will hide all rows below row 4 and all columns to the right of column F.
Adjust the ranges as needed. The hidden area will become solid gray.

Sub Macro1()
Rows("5:65536").Hidden = True
Columns("G:IV").Hidden = True
End Sub