Add/Hide lines in invoice or qoute

**Jakes** · 03-22-2011, 08:01 AM

Good day,
Maybe someone can help me? I have made a simple invoice/quote system in excell, with a max of 15 items. Now I want to know if it is possible to hide the lines not used in the excell sheet?

I have attached the excell file for an example

Thank you very much

Jakes

**royUK** · 03-22-2011, 09:30 AM

Maybe like this

Please Login or Register  to view this content.

**Jakes** · 03-22-2011, 09:41 AM

Originally Posted by royUK

Maybe like this

Please Login or Register  to view this content.

It work, yes, thank you. is there a possibility to make it work as a hide/unhide toggle option? My problem is when I edit a quote, and add an item, it does not add the new line then..

**royUK** · 03-22-2011, 12:15 PM

Restore the lines after Printing

Please Login or Register  to view this content.

**Jakes** · 03-22-2011, 05:08 PM

Thanks, that's perfect!

**mieliepap** · 09-08-2011, 05:38 AM

I am trying to do the same thing, I don't really see how to use this though.
I've pasted the code into the code of the sheet, but can't see which cells it is affecting, etc. Some guidance please?
That is, on the hide part of the code.