Print Button Macro

[zinctek]

Hello

Am after abit of help.

I need to make a print button on my excel sheet but i dont know how to do it. i need to be able to print A1 to G5 for example. how would i go about doing that?

Thanks for your help

[davesexcel]

If you know how to create a button, this bit of code should do the trick

Please Login or Register  to view this content.

[zinctek]

i have done that but when i click on the button nothing happens? what could be wrong?

[royUK]

To best describe or illustrate your problem you would be better off attaching a dummy workbook, the workbook should contain the same structure and some dummy data of the same type as the type you have in your real workbook - so, if a cell contains numbers & letters in this format abc-123 then that should be reflected in the dummy workbook.

Attach the one that you have the button in

If needed supply a before and after sheet in the workbook so the person helping you can see what you are trying to achieve.

Doing this will ensure you get the result you need!

[zinctek]

sorry to reply a few months later. i manged to get that to work thank you very much.

What is the code to pop up to ask how many copies when i click the button?

Thanks
Dave

[davesexcel]

Hi dave,

What did you do to get it to work

[zinctek]

If you know how to create a button, this bit of code should do the trick

Please Login or Register  to view this content.

I ended up trying it again after a few months and it just worked. i think i was putting it in the wrong place or doing it wrong