一下代码实现一个始终显示在Excel前的窗体,不论你怎么切换工作表它都不会消失。当Excel最小化时它会与Excel窗口一起从桌面上消失。
using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using Microsoft.Office.Tools.Ribbon;
using Excel = Microsoft.Office.Interop.Excel;
using System.Runtime.InteropServices;
using System.Windows.Forms;
namespace AModlessFormInExcel
{
public partial class Ribbon1
{
private void Ribbon1_Load(object sender, RibbonUIEventArgs e)
{
}
private void button1_Click(object sender, RibbonControlEventArgs e)
{
Excel.Application XlApp = Globals.ThisAddIn.Application;
Form1 frm = new Form1();
frm.Show(NativeWindow.FromHandle(new IntPtr(XlApp.Hwnd)));
}
}
}
相关资源:http://download.csdn.net/detail/tx_officedev/4106151