Poundland
06-30-2008, 07:23 AM
Guys,
I have an issue.
I have written some code which formats a series of reports into one master report and then sends an email informing end users of its collation.
Now my issue is that once the formatting is complete I want the macro user to be able to view the report for any anomolies in the data prior to sending the emails.
How can i using VBA programme in a Pause in the VBA code that when the user is ready they can press a key and complete the VBA run?
I have an issue.
I have written some code which formats a series of reports into one master report and then sends an email informing end users of its collation.
Now my issue is that once the formatting is complete I want the macro user to be able to view the report for any anomolies in the data prior to sending the emails.
How can i using VBA programme in a Pause in the VBA code that when the user is ready they can press a key and complete the VBA run?