klitton7
asked on
How do I modify a macro to include formatting - need to add an extra row and bold certain text.
The attached file has a macro which inserts subtotals on each page. There are two controls for adding subtotals and removing the subtotals - buttons at the top of the form.
I need assistance in modifying the macros so that when the subtotals are visible, the following formatting takes place. An additional blank row appears above the subtotals, there are no boarders around the subtotal row and the subtotal row is in "bold." When the remove subtotal button is selected, the extra row is deleted. I have attached the document. As a side note, Glen Ray assisted on 7/22/2014. ID#40210902.
H--Documents-Bad-Debt-Log-Master-2.xls
I need assistance in modifying the macros so that when the subtotals are visible, the following formatting takes place. An additional blank row appears above the subtotals, there are no boarders around the subtotal row and the subtotal row is in "bold." When the remove subtotal button is selected, the extra row is deleted. I have attached the document. As a side note, Glen Ray assisted on 7/22/2014. ID#40210902.
H--Documents-Bad-Debt-Log-Master-2.xls
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER