Print-Macro help

[jamesdigol]

Hi everyone. I have a template which is an excel file. It has 2 sheets in it, Sheet 1 and Sheet 2. I wish to make a Print button and place it in Sheet 1 then pressing it will print the 1st page of Sheet 2 only. Can you guys help me make a macro for it. thanks..

[h.veen]

Place a commandbutton on Sheet 1 and put this code in the VBA Editor on Sheet1

Please Login or Register  to view this content.

Place the next code in Module1

Please Login or Register  to view this content.

Please Login or Register  to view this content.

To find the right name of your printer, print a sheet while running the macrorecorder.

[jamesdigol]

geez..thanks a lot!

[jamesdigol]

Hi again Mr. h.veen!

Sir, if it isn't much to ask, could you please attach an example .xls file with this code you've given because when i tried pasting the code, i only got error. I'm sorry but I really don't know much about macros.

[h.veen]

Can you upload your file?

[h.veen]

Try this file. It makes a print preview of sheet2

[jamesdigol]

thanks again Mr. h.veen for your time. Please take a look at this file below. Also, i wish to rename the "CommandButton1" into "Print Form", is it possible to change that? (i forgot, the file is protected, it's password is jld)...

[h.veen]

Try this file.

[jamesdigol]

wow great!...thanks a lot mr. hveen i hope this won't be the last. ur such a great help