Excel - Need macro to print multiple worksheets

Status
This thread has been Locked and is not open to further replies. Please start a New Thread if you're having a similar issue. View our Welcome Guide to learn how to use this site.

GreasedLizard

Thread Starter
Joined
Apr 20, 2010
Messages
1
Hi all,

the title of the post only gives part of the story.

What I'm looking for is a VBA script to attach to a button. When the user clicks the button I need each of the worksheets within the workbook to be checked for an entry (say in cell A8), and to only print the ones that have a value (the value will be different on each sheet, so another way to look at it is a check that does not print worksheets with no value in that cell).

For example: The workbook has 5 worksheets to check (A, B, C, D and E). A8 is completed on sheet A, D and E. When the user clicks the button, sheets A, D and E are the only ones that should print.

Hope I have been clear enough with what I need!

Thanks in advance for any help you can provide.
 

Keebellah

Hans
Trusted Advisor
Joined
Mar 27, 2008
Messages
6,612
Hi welcome to the forum.

I have a piece of code which I found and have been using since.
It's in the sample sheet and you will have to workout some things for yourself like the filetr for the sheets you wish to print.

There is a simple explanation in Sheet3 and 2 buttons which can help you on the way. ;)

The code is as is.

Happy coding :)

PS excuse my mispelling greased
 

Attachments

Status
This thread has been Locked and is not open to further replies. Please start a New Thread if you're having a similar issue. View our Welcome Guide to learn how to use this site.

Users Who Are Viewing This Thread (Users: 0, Guests: 1)

As Seen On
As Seen On...

Welcome to Tech Support Guy!

Are you looking for the solution to your computer problem? Join our site today to ask your question. This site is completely free -- paid for by advertisers and donations.

If you're not already familiar with forums, watch our Welcome Guide to get started.

Join over 807,865 other people just like you!

Latest posts

Staff online

Members online

Top