Print UserForm for multi-sheet printing

Closed
bth117 - Nov 18, 2008 at 05:15 PM
 th - Dec 14, 2008 at 04:02 PM
Hello,

I would like to write a macro that prompts a UserForm to select which sheets/tabs to print from a workbook. This macro should identify the names of all the sheets in the file and display them in the userform with a checkbox next to each sheet, so the user can click which sheets he wants to print. Then there should be a Print button at the bottom.

The part I am hung up on is identifying/importing the names of the sheets in a given workbook. I would like this macro to work for any excel file.

Any help would be appreciated.

-Brian

1 response

Try this:

'VBA Express : Excel - Print Manager on a Userform

'http://www.vbaexpress.com/kb/getarticle.php?kb_id=129#instr

User form reads tabs, drop and drag to set order. Seems to work well in Excel 2003. Even allows to select the printer to use.
2