Macro for setting Print Area

Hi there

I'm creating a user-friendly purchase order form, I have a vba whereby users can add a new supplier, and also to print.
The reason why I need a print button is to have an easy way to select a print area as the worksheet looks like this -

Capture.PNG

Is there easier way to achieve a standard print area? This workbook will be accessed and used on a wide network of individual computers.
I am getting the current message for my 'print' button macro.

Capture1.PNG

The command is in Module1 - I am not very advanced on excel so may be working backwards to you lot

Any help is appreciated!

Are you looking to call that function in Module1? If yes, then you need to write this in the place where you have written Activate Module1:

Please Login or Register  to view this content.

Is that what you are looking for?

Thanks,
V

Yes thank you very much