MichaelWayne_71
Board Regular
- Joined
- Nov 9, 2005
- Messages
- 60
Hi all,
I have seen a macro b4 that, when clicked, hid all of the ROWS with a zero value. I cannot get the sheet unlocked to figure out how they did it. I am okay in excel with formulas but, just starting with VBA and am very weak with it.
e.g.--I create sales proposals from hundreds of different products. Some
values will change automatically based on selection in another (a cable
that is required for a printer, etc...) I would like to be able to shrink
the list before I print it out without having to hide all rows that list
products that do not pertain to their proposal.
Detailed help would be appreciated!!!
Thank you!
I have seen a macro b4 that, when clicked, hid all of the ROWS with a zero value. I cannot get the sheet unlocked to figure out how they did it. I am okay in excel with formulas but, just starting with VBA and am very weak with it.
e.g.--I create sales proposals from hundreds of different products. Some
values will change automatically based on selection in another (a cable
that is required for a printer, etc...) I would like to be able to shrink
the list before I print it out without having to hide all rows that list
products that do not pertain to their proposal.
Detailed help would be appreciated!!!
Thank you!