关于防止Excel文档被编辑的方法。-优快云博客

本文介绍两种锁定Excel文档的方法：一是设置Final属性实现只读；二是利用BeforeSave事件阻止保存更改，适用于不同需求。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

第一种方法是设置Workbook的Final属性为True。这样整个文档就只读了。但是这样的话文档会提示你是否取消只读（实际上与没设一个样。）

第二种方法是编辑Workbook的BeforSave事件。在BeforSave事件中将Cancel设为True。这样的话在你关闭Excel时只要你有任何操作，不管事前你点了保存按钮与否它都会跳出提示框要你保存文档（你当然要点保存了——虽然什么改动都不会被保存，不然就没法退出Excel了）。想取消这个设置是个技术活。用它对付小白估计是够用了。

相关代码：

using System;
using System.Collections.Generic;
using System.Data;
using System.Linq;
using System.Text;
using System.Windows.Forms;
using System.Xml.Linq;
using Microsoft.Office.Tools.Excel;
using Microsoft.VisualStudio.Tools.Applications.Runtime;
using Excel = Microsoft.Office.Interop.Excel;
using Office = Microsoft.Office.Core;

namespace ExcelWorkbook8
{
    public partial class ThisWorkbook
    {
        private void ThisWorkbook_Startup(object sender, System.EventArgs e)
        {
            Excel.Workbook objWorkbook = Application.ActiveWorkbook;
            objWorkbook.Final = true;
        }

        private void ThisWorkbook_Shutdown(object sender, System.EventArgs e)
        {
        }

        #region VSTO Designer generated code

        /// <summary>
        /// Required method for Designer support - do not modify
        /// the contents of this method with the code editor.
        /// </summary>
        private void InternalStartup()
        {
            this.Startup += new System.EventHandler(ThisWorkbook_Startup);
            this.Shutdown += new System.EventHandler(ThisWorkbook_Shutdown);
        }

        #endregion

    }
}

using System;
using System.Collections.Generic;
using System.Data;
using System.Linq;
using System.Text;
using System.Windows.Forms;
using System.Xml.Linq;
using Microsoft.Office.Tools.Excel;
using Microsoft.VisualStudio.Tools.Applications.Runtime;
using Excel = Microsoft.Office.Interop.Excel;
using Office = Microsoft.Office.Core;

namespace ExcelWorkbook8
{
    public partial class ThisWorkbook
    {
        private void ThisWorkbook_Startup(object sender, System.EventArgs e)
        {
            Excel.Workbook objWorkbook = Application.ActiveWorkbook;
            objWorkbook.BeforeSave +=
                new Excel.WorkbookEvents_BeforeSaveEventHandler(
objWorkbook_BeforeSave);
        }

        void objWorkbook_BeforeSave(bool SaveAsUI, ref bool Cancel)
        {
            Cancel = true;
        }

        private void ThisWorkbook_Shutdown(object sender, System.EventArgs e)
        {
        }

        #region VSTO Designer generated code

        /// <summary>
        /// Required method for Designer support - do not modify
        /// the contents of this method with the code editor.
        /// </summary>
        private void InternalStartup()
        {
            this.Startup += new System.EventHandler(ThisWorkbook_Startup);
            this.Shutdown += new System.EventHandler(ThisWorkbook_Shutdown);
        }

        #endregion

    }
}