Hi all,
How do I create a popup window to confirm that a macro finished running?
I have a button in the worksheet that when clicked, it will print out 2 worksheets. But I want a confirmation stating "Printing Complete"
Here's my code:
Sub Print_Stage1_sheets()
'
' Print_Stage1_sheets Macro
' This prints the Reg 60 Checklist & the outgoing letter
'
'
Sheets("Reg60 Checklist").Select
ActiveWindow.SelectedSheets.PrintOut Copies:=1, Collate:=True
Sheets("Stage 1 outgoing letter").Select
ActiveWindow.SelectedSheets.PrintOut Copies:=1, Collate:=True
Sheets("Information Input").Select
End Sub
Thank you,
John
Bookmarks