Ankur, your welcome
--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003

"Ankur" wrote in message
...
thanks paul.

"Paul B" wrote:

Ankur, file, print, print what, select entire workbook
--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003

"Ankur" wrote in message
...
if suppose there are 15 worksheets in a file & i have to print all
these
worksheet with fixed format, is there any commnad to print at once
instead
of
going to every worksheet and give print command