Add a macro to a button to print whole workbook

hi,
i got a workbook, that has many pages.
i need to insert a button with a macro, ( Print Workbook ) to scroll all the workbook and print all the sheets, but on every sheet, to stop to last value, and not to print blank pages.
or,
a dropbox to ask me which pages to print is even better, but still every sheet up to last value.

i hope i did explain it well, but if you need the workbook, let me know to upload it.

Many thanks in advance.

Originally Posted by davesexcel

Check out Jwalk's example

http://www.j-walk.com/ss/excel/tips/tip48.htm

hi, thanks, i give it a go, and i hope i can modify it if needed. ( not that i'm an expert, but i give it a go)

any help??
please?

anyone to help me with this?

Originally Posted by abduljaleel.mca

Use this code before printing code...

Please Login or Register  to view this content.

hi again, and thanks for your help.
i upload the same sheet we was working on before.
where this code goes? can you have a look when you can?

also, the search you put on the sheet works fine, but if you input nothing on the search boxes, or if you cancel the search, deletes all the prices from the sheets, i'm sure is an easy fix
thanks in advance

Project.xlsm

Use this updated file...
I am looking in to your 2nd issue...

thank you i wait for it.

Originally Posted by abduljaleel.mca

Use this updated file...
I am looking in to your 2nd issue...

also, the search not having a function: "Not Found Product Name" so i know if found it or not.

sorry to truble you

Please let me know if this file solves all of your issues..

Originally Posted by abduljaleel.mca

Please let me know if this file solves all of your issues..

hi, thanks for the search, now is working ok.

printing, is only prints now the first page of the sheet, from a1 to I3.
maybe because is the cells merged, but not printing the whole document.

I don't have the printer to check the code before sending it to you ...Let me check the code again...

change this line

Please Login or Register  to view this content.

to

Please Login or Register  to view this content.

Thanks, works perfect. !!
just a question before i close the thread, do i need to leave the tab "dialog1" on the workbook, or is ok to delete it?

thanks

U can delete it once your process is over...

Originally Posted by abduljaleel.mca

U can delete it once your process is over...

thank you !!