Hello Let me clarify my problem. I created a form that has 8 columns .
Whenever a sales rep makes an error they fill out the form and send a copy to
3 other people. After the sales rep makes the entries in the form and sends
it out they save and close the file . What I want to do is when the file is
saved and closed to hide the row with the information, so when the next
person opens the form it appears empty.(I want the first row with the
labels to be visible. ) So by hiding them I can create a pivot table at the
end of the month Thank you

"Wanna Learn" wrote:

Hello
Is it possible to hide all visible rows (except row 1) evertime the workbook
is saved and closed . (I want to later on unhide the rows and create a pivot
table )