Worksheet.Unprotect问题 [英] Worksheet.Unprotect issue

问题描述

当我尝试用不正确的密码取消保护工作表时，Excel会打开自己的Worksheet Unprotect对话框。如何抑制对话框，并知道workheet.UnProtect（）是否已成功？

When I try to unprotect the worksheet with incorrect password the Excel brings up its own Worksheet Unprotect dialog . How can i suppress dialog and know if the worksheet.UnProtect() succedded or not?

我正在使用Excel 2007版本并且确实对这个版本感到震惊。

I am using Excel 2007 version and really struck on this one.

问候，

Devinder

推荐答案

在运行生产线之前设置显示警告false ..然后回到后面

set display alerts false prior to running the line.. then back afterwords

Public Sub Example()
 Dim bAlerts As Boolean
 bAlerts = Application.DisplayAlerts
 
 If Not Application.DisplayAlerts = False Then Application.DisplayAlerts = False
 
 ' Do your work here in this case unprotecting your sheet
 
 If Not Application.DisplayAlerts = bAlerts Then Application.DisplayAlerts = bAlerts 
End Sub

这篇关于Worksheet.Unprotect问题的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！