Three worksheet tied together while copying

[mohtogh]

Hi,
I know title is not clear.
I have sheet 1,sheet 2,and sheet 3 in one workbook.
I want tied together theses worksheets (for ever), and then hide sheet 2 and sheet 3.So if somebody wants copy sheet 1 to other workbook, those two hidden worksheets, 2 and 3 ,automatically go with sheet 1. Is that possible?

Thanks for your replies

 

[pmover]

unfortunately, no. the worksheets must be selected for copying to another workbook. unless vba code is written to conduct such a request.

-pmover

 

[bltseattle]

I don't know how to do exactly what you want. But what you could do is put the data from sheets 2 and 3 onto sheet 1 and hide the columns(or rows). You can use the protection functions to prevent someone from un-hiding these cells.