I am new here and this is my first post. I have reviewed, searched, and read the forums for this issue and cannot find it. I apologize if this issue is already answered somewhere and please send me a link if you know where the answer resides.
I have an Excel 2007 workbook where users complete a form (sheet1) and I need a macro (or code segment that I can include in my other macros) that will print the second, third, or fourth sheet (these are form letters contining the information entered into the form) based on the value of a combo list box ("Drop Down 2") which is one of the data entry values on the form. Right now, sheets 2 ,3, &4 are Visible and the users must decide which to select and print, but I'd prefer they remain hidden.
For example, if:
I already have macros for clearing the form, protecting everything, and 'stamping' the data into a database of all previosly entered data, so perhaps the commands I need can simply be added to the "submit Data" macro.
Many thanks for reading...
I have an Excel 2007 workbook where users complete a form (sheet1) and I need a macro (or code segment that I can include in my other macros) that will print the second, third, or fourth sheet (these are form letters contining the information entered into the form) based on the value of a combo list box ("Drop Down 2") which is one of the data entry values on the form. Right now, sheets 2 ,3, &4 are Visible and the users must decide which to select and print, but I'd prefer they remain hidden.
For example, if:
- the value of "Drop Down 2" = 1 9default), then print nothing
- the value of "Drop Down 2" = 2, then print sheet 2
- the value of "Drop Down 2" = 3, then print sheet 3
- the value of "Drop Down 2" = 4, then print sheet 4
I already have macros for clearing the form, protecting everything, and 'stamping' the data into a database of all previosly entered data, so perhaps the commands I need can simply be added to the "submit Data" macro.
Many thanks for reading...