Excel file getting freeze when i open any WPF window by click on Ribbon

Question

I have one C# EXCEL application made in VSTO. I have several buttons in ribbon which will open respective WPF(xaml) Windows.

My problem is, When I click on any ribbon button then respective WPF page will opens and then I can not access that excel file till that WPF window is opened. Once I close that WPF window then I can able to access excel again, so I want to access excel file even if any wpf window is opened so that I can use other functionalities of ribbon simultaneously.

How can I do that ?

Answer 1

Use Show() instead of ShowDialog()

Answer 2

var window = new MainWindow();

// this will set focus back to excel after window closed.
window.Closed+=(sender, e)=> System.Wndows.Threading.Dispatcher.ExitAllFrames();

window.Show();
System.Windows.Threading.Dispathcer.Run(); // push this to the queue so the textbox can be focused