一个始终显示在Excel前的窗体
一下代码实现一个始终显示在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
征诛志异,三让两家王朝;功同开辟,一桮万古江南。