From a popup vb form, user previews a worksheet. While still in preview, without closing the preview screen, the user clicks on another worksheet which brings up the following message:
error title: Component Request Pending
erro Desc: An action cannot be completed because a component (Microsoft Excel-
File1.xls) is not responding. Choose "Switch to" to activate the
component and correct the problem.
[Switch To...] [ Retry ] [ Cancel ]
I want to either intercept and replace this message with a more user friendly message or close the worksheet presently in preview mode.