click button and print sheet

Good evening Sonyk

Originally Posted by Sonyk

I wanna know how can I print a sheet by clicking in one button (The VB Code)

Try recording a macro (Tools > Macro > Record New Macro), then printing your worksheet whilst recording.
Once you have the macro recorded, open the Forms toolbar, find the button tool, draw your button, then assign your new macro to it.

HTH

DominicB

Or just customize the Quick Access toolbar, and add the Quick Print button.

please illustrate how to store user data input,in a table and then use one or more data cells in a formula i am using excell 2003,with my regards

Please take a few minutes to read the forum rules, and then start your own thread.