Excel

Here is a routine that will;

1) Select certain sheets depending on weather a range [A1] has "Print" in it.

Conditions:

You could have setup some sheets that you want printed only if certain conditions are met.

On these sheets you could place a formula to test for these conditions and if True then return "Print" in A1. Now when you need to only print these sheets, just run this routine.

Obviously you can change the criteria, but this is just to get you going in the right direction.

If you have a macro that is in a loop to print the page if it has "Print", each page will print individually which, on a network printer may not print in order i.e. everyone elses print jobs come through interspersed with your document. What you really need to do is select ONLY those pages you want printed and then print them all together. Looping though each sheet and then printing them one @ a time doesn't gaurantee that the jobs come out on a networked printer as one print job. Here is one way to do this.

The 1st part of the routine looks for the 1st sheet with the criteria "Print" @ A1, change this as required. This 1st routine is important as when you are group selecting from a sheet that does NOT have the criteria in it, this sheet will be included.

The 2nd part then goes through each sheet and groups the ones with the criteria.

Now all that is left to do is Prnt