How make a macro print a spreadsheet with the click of a build in button in the spreadsheet?

Question

How do you make a buttom, that when clicked the spreadsheet prints?? I guess using Macros is the only way... I need to know the exact macro to put in and link to the button...

Answer 1

Hi
This is the first thing you can learn in VBA of Excel
- go to Tools > Macro > Record new macro
- and do the printing you want
- Stop the recorder
- Now go to the VBE (ALT + F11) and see what Excel did for you in the "module1" it added.
- Go back to Excel (ALT + F11) and draw a command using View > Toolbars > Forms
- The command will ask you which macro you want to assign this command to.
- Select your macro (If you didn't change it)

I hope this will answer your question

PS: Your answer on WEEKDAY( TODAY()) was wrong, I posted the correct answer there.

Trust me, I am the VBAXLMan

Answer 2

I don't know about a macro, but couldn't you attach some visual basic code to the button?

Just a thought.