Hi - I print labels for products that can have between 3 and 8 components and multiple quantities. These products have to be packed each week and to distinguish them each set of labels is coloured differently. The spreadsheet attached is an example. I've written some code, the user selects a colour in Sheet Labels cells J2:J12 then runs the CreateLabel code which picks up values from Costing and Written Quote sheets. The label layout is different if cell B13 in Costing is greater than 0. This part of the code works okay and populates the fields and I set the print area based on number of labels 6 to a page. What doesn't work is when I go to print the labels nothing is set out correctly. It appears excel overrides my values and sets pages to something random so I have to manually adjust in View/Page Break View and then set the margins and other values.
Does anyone have anything that sets print values consistently ?
The labels are a4 six to a page with a margin of about 5mm around all edges. Happy to provide more information if required.
I doubt I'm the first person to want to print labels from excel so am hoping there's something out there already.
Thanks