jimmywanna
Board Regular
- Joined
- Mar 18, 2002
- Messages
- 182
HELP!
I have been given a project at work, I have an excel sheet in a workbook which is a page of labels.
I have made the previous sheet contain fields for the user to input things like expiry date and batch number, these are linked to cells on the "label sheet"
It all works fine, BUT:
I need to be able to print a defined number of "sheets" of labels.
I have used a control button which runs a macro in the past to print a defined number of sheets using the following code:
Sub LABELPRINT()
'
' LABELPRINT Macro
'
Sheets("LAYOUT").Select
ActiveWindow.SelectedSheets.PrintOut Copies:=1, Collate:=True
Sheets("Sheet1").Select
ActiveWorkbook.Close SaveChanges:=False
End Sub
I didn't write this as i don't have a great knowledge of VBA, I just recorded the macro
Is there any easy way of allowing the user to define hown many "copies" of the selected sheet that are printed.
I have tried to make a userform but i don't know quite how to use them.
Can i link a user input from a cell to define the number of copies?
I would really appreciate any help on this as it is driving me mad.
Thanks.
I have been given a project at work, I have an excel sheet in a workbook which is a page of labels.
I have made the previous sheet contain fields for the user to input things like expiry date and batch number, these are linked to cells on the "label sheet"
It all works fine, BUT:
I need to be able to print a defined number of "sheets" of labels.
I have used a control button which runs a macro in the past to print a defined number of sheets using the following code:
Sub LABELPRINT()
'
' LABELPRINT Macro
'
Sheets("LAYOUT").Select
ActiveWindow.SelectedSheets.PrintOut Copies:=1, Collate:=True
Sheets("Sheet1").Select
ActiveWorkbook.Close SaveChanges:=False
End Sub
I didn't write this as i don't have a great knowledge of VBA, I just recorded the macro
Is there any easy way of allowing the user to define hown many "copies" of the selected sheet that are printed.
I have tried to make a userform but i don't know quite how to use them.
Can i link a user input from a cell to define the number of copies?
I would really appreciate any help on this as it is driving me mad.
Thanks.