I have a form and on it I have shaded areas where I have folks input data.
This form can be printed on either regular bond paper (when the form is not available in the field), or a standard purchased form.
I need a macro that:
Form is area B6:C8 for this example...
1. when BUTTON 1 is pressed it will print all data on form but not the shaded color, it can print the text, but not the color.
2. when BUTTON 2 is pressed it would print only the text in the shaded area but nothing else, no borders, no headings, no color, just the "consignee" information.
3. BUTTON 3 whem pressed would make a copy of the sheet and put it at the end. The copy would need to have all the buttons copied too.
I tried doing this with the macro recorder but it kept putting the sheet after a particular sheet and not at the end and it would not copy the buttons.
This form can be printed on either regular bond paper (when the form is not available in the field), or a standard purchased form.
I need a macro that:
Form is area B6:C8 for this example...
1. when BUTTON 1 is pressed it will print all data on form but not the shaded color, it can print the text, but not the color.
2. when BUTTON 2 is pressed it would print only the text in the shaded area but nothing else, no borders, no headings, no color, just the "consignee" information.
3. BUTTON 3 whem pressed would make a copy of the sheet and put it at the end. The copy would need to have all the buttons copied too.
I tried doing this with the macro recorder but it kept putting the sheet after a particular sheet and not at the end and it would not copy the buttons.
Book1 | ||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|
A | B | C | D | E | F | G | H | I | J | |||
2 | ||||||||||||
3 | BUTTON1 | BUTTON2 | BUTTON3 | |||||||||
4 | PrintonReqularPaper | PrintonForm | CopythisForm | |||||||||
5 | ||||||||||||
6 | Consignee | test1 | ||||||||||
7 | address1 | |||||||||||
8 | state1 | |||||||||||
9 | ||||||||||||
Sheet1 |