Urgent - print macro button

[jin]

Hi,

I need to know how to make a box that says "print" which will print out pages in my excel file... What I am picturing is this:

Tab 1 Y
Tab 2 Y
Tab 3 N
... etc.

Making a table as the one above, and depending on whether I input "Y" or "N", it will print that tab...

i've seen this in some financial models and would like to incorporate it into my model. If you could offer some detailed help, it would be greatly appreciated. Please note that I am a complete beginner and would need to be taken step-by-step.

Thanks again.

 

[Smitty]

Welcome to the Board!

See: http://www.vbaexpress.com/kb/getarticle.php?kb_id=528

 

[Trewsue]

Thanks Smitty,

I can see how this would work on a small system (will be brilliant for some projects I'm working on with specific sites) however on the network I'm dealing with we have 107 sites and 700+ printers.
I'm marginally happy with changing .Printout to .PrintPreview which forces a tedious version of the same end product, however would be happier still if I could select the list, then go to the dialogue box I would get by selecting Ctrl+P....

Any hints?

Thanks
Sue