.. each branch does a 'format, row, hide' on certain rows to hide that
data, since they do not use that item in their branch...

Perhaps, instead of hiding the certain rows in that filtered range, the user
should just delete the rows ? This would solve the issue cleanly.
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"RPW" wrote:
I have a workbook with 3 columns of data- item number, description and
vendor. There are drop down menus at the top of each column, so a user can
choose, for example, to look at items from only a certain vendor. In
addition, each branch does a 'format, row, hide' on certain rows to hide that
data, since they do not use that item in their branch.

If a user has hidden any rows of data, then they choose a vendor from the
drop down box, then choose 'All' from the drop down box to return the sheet
to its original form, at that point, ALL the rows appear, even the ones that
were hidden, and the sheet then saved. I do not want the hidden rows to
reappear, how do I do that? Thank you.