BTW,

I just read the ENTIRE question.

I would suggest NOT makein a new sheet for every day. The reason is clear
why you want it, to creat a history.

I would append the current days data to one worksheet (**) and add a date
column. The tabs look pretty BUT when you're trying to go back and validate
or group say 1 months worth of data, it's going to cause you great pain.

** If you're going to have too many rows to append to one worksheet (ie more
than 65536) make a table in access to append the history too.

Also, making a new tab for each day will make managing the workbook a
nightmare in a short amount of time.



"excel-lent" wrote:

>
> I'm using the ActiveWindow.SelectedSheets.PrintOut to print out sheets
> that I select (i have three sheets). When i invoke the macro with any
> combination of selected sheets it deselects the first two sheets and
> only prints the third.
>
> Any help with this one would be great. This forum has a-lot to offer,
> but cant find the specifics.
>
> Thanks in advance for your help.
>
>
> --
> excel-lent
> ------------------------------------------------------------------------
> excel-lent's Profile: http://www.excelforum.com/member.php...o&userid=24298
> View this thread: http://www.excelforum.com/showthread...hreadid=379037
>
>