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.

.. 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.

If the rows cannot be deleted, maybe set up a new column to identify the
columns that should remain hidden (perhaps "H" for hidden and "V" for
visible). Filter this column for "V". When the other filters are set to
show all this one should keep the desired rows hidden.

"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.

I like this idea, but how do I set up filters for some of the columns, but
not all. It wants to set up filters for all of the columns when I choose
'data', filter, autofilter, even if I highlight only the columns I want.

"JMB" wrote:

If the rows cannot be deleted, maybe set up a new column to identify the
columns that should remain hidden (perhaps "H" for hidden and "V" for
visible). Filter this column for "V". When the other filters are set to
show all this one should keep the desired rows hidden.

"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.

You may need to insert empty cols to separate.
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"RPW" wrote in message
...
I like this idea, but how do I set up filters for some of the columns, but
not all. It wants to set up filters for all of the columns when I choose
'data', filter, autofilter, even if I highlight only the columns I want.