possible to keep row hidden when filter cleared/used?

[Ben Millen]

Hi all, so on the form im making a row is hidden, that row is used to create new rows with the same properties

however whenever i apply or clear filters this row is unhidden

any way to stop that?

 

[Luke M]

Can you move the row somewhere outside of filtered area, and then have formatting/formulas copied from there to new rows?

 

[Ben Millen]

not sure to be honest, its part of a table so not sure if it would work

 

[Luke M]

Could you make the row height very small, like 0.01? That way, it's still unhidden, but can't quite be seen.

 

[Ben Millen]

i like your thinking but that doesnt seem the best way to do it, several people will be using the form and i dont want anything that will cause questions or that they can mess up

 

[Luke M]

Can you upload an example of your table? I'm not sure what other options we might have.

 

[sgmpatnaik]

@Ben

Why not you use the Worksheet_Change event when you change any thing then the row to be hide

 

[NARAYANK991]

Hi Ben ,

I don't understand what properties are present in the hidden row , which will not be present in added rows ; can you clarify ?

If at all you are using VBA to customize any row that is added , why should the properties be copied from a hidden row ? Can they not be coded in the VBA procedure itself ?

Narayan

 

[Ben Millen]

guys im new to this so dont really understand your suggestions

ive got conditions that need to be applied to the rows (change color depending on dates)

heres a copy of the file

 

[NARAYANK991]

Hi Ben ,

Can you see if this is OK ?

See this link for more information on how to work with Excel Tables using VBA :

http://www.jkp-ads.com/articles/Excel2007TablesVBA.asp

Narayan

 

[Ben Millen]

Hi Narayan, just looked at this, doesnt seem right though, it inserts the row at the bottom and doesnt apply the rules

 

[NARAYANK991]

Hi Ben ,

Do you want that the new row should be inserted at the top of the table ?

Narayan

 

[Ben Millen]

Hi Narayan, yeah thats what it did before

 

[NARAYANK991]

Hi Ben ,

Since you say it does not apply the rules , can you say how I can test this ?

I had checked it before uploading the file , and from what I could see it worked.

Narayan

 

[Ben Millen]

sorry Narayan it does apply them, my mistake

 

[NARAYANK991]

Hi Ben ,

See if this is OK.

Narayan

 

[Ben Millen]

thats great Narayan, thanks, it was copying the color from the header but i fixed that with ".Interior.Color = xlNone"

thanks for your help on this