Hi All
I would appreciate any help with my problem, as I am a beginner at VBA.
I have attached a simple sample spreadsheet to show what I need to be done.
I need a VBA code so that when a user presses on the Print command button it will print the area which I have defined as a print area beforehand i.e. I have selected a set print area to be from a4:a20 and I need this area to be printed in Landscape and all fitted in one sheet on a selected printer and in colour.
I have various worksheets in my actual workbook and all have different areas to be printed. Im not sure what is the best way to set this up i.e. I set the print areas beforehand or allow the user to to this via the VBA code. I need to distribute the spreadsheet to all my directors and they should be be to print their relevant worksheet by clicking on the print button which I have inserted on every worksheet for them. But I do need them to be able to select their printer or just automatically choose their default printer (I think the later will be easier to do) as this worksheet will be distributed to various departments.
I hope I am clear in what I want to do. In summary when a user clicks on Print button, it will select the user’s default printer and prints the pre-selected print area on one sheet and in landscape and colour.
Any help is appreciate it
Bookmarks