<div>
I have tried the codes above.<br />
<br />
MacroShadow's works well even if you print multiple sheets.<br />
<br />
Rgonzo1971's is simple but can only print one sheets. if you select multiple sheets, it will only print the original sheet.<br />
<br />
thanks guys. i also used this
</div>


I have tried the codes above.

MacroShadow's works well even if you print multiple sheets.

Rgonzo1971's is simple but can only print one sheets. if you select multiple sheets, it will only print the original sheet.

thanks guys. i also used this

<div>
<div class="content wysiwyg-content">
Hello Gurus,<br />
<br />
Is there a &nbsp;after print event in VBA? For example I want to clear a range every time the users press the print button to print? But I need the range to clear-ONLY after the print job has ended and printing finished<br />
<br />
Thank you
</div>
</div>


Hello Gurus,

Is there a  after print event in VBA? For example I want to clear a range every time the users press the print button to print? But I need the range to clear-ONLY after the print job has ended and printing finished

Thank you

After Print Event VBA

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.

Microsoft Excel

Microsoft Office is an integrated suite of applications that includes Outlook, Word, Excel, Access, PowerPoint, Visio and InfoPath, along with a number of tools to assist in making the individual components work together. Coding within and between the projects is done in Visual Basic for Applications, known as VBA.