Leaving aside the issue of ribbon, if your procedure provides for programmatically displaying the print preview and then any other actions, then the code execution is suspended while the preview window is displayed. Will move on only after the window is closed. That is why I expressed my concerns that this task may not be feasible from within Excel. This would probably be possible from the COM add-on level. But COM is not my garden.
At least I would ask you to confirm that the task cannot be solved from within Excel.

Artik