Printing Macro-to click a print button

[acinom]

I have 6 worksheets and an entry sheet in my excel 2007 workbook. I need to create a macro print button that will print a certain number of copies of each worksheet based on a number in cells on the entry sheet. For example my worksheets are all departments of my store and the entry sheet has numbers of employees per department. I want to be able to click a print button and it automatically print enough worksheets per employee per department.

[p24leclerc]

here is a macro that could help you.
You need to have a first sheet where you'll create a two columns table:
in A you put the sheets name
in B you put the number of copies you need of it.
I give the sheet the name "Entry". If you don't use this name, change the macro accordingly.

Give a name to this range (it could be the same as in macro "dept_empl"
I have a VLOOKUP function to pull out the number of copies required.

Please Login or Register  to view this content.

End Sub

Pierre

[royUK]

You don't need to VLOOKUP the number of sheets

Assuming the store name is in A1 and the specific sheet is named as the text in A1 & the number of employees in B1

Select A1 then run the code

Please Login or Register  to view this content.