다음을 통해 공유

Workbook.VBASigned Property (Excel)

  • 아티클

True if the Visual Basic for Applications project for the specified workbook has been digitally signed. Read-only Boolean.

Syntax

식 .VBASigned

식 A variable that represents a Workbook object.

Example

This example loads a workbook named “mybook.xls” and then tests to see whether its Visual Basic for Applications project has a digital signature. If there’s no digital signature, the example displays a warning message.

Workbooks.Open FileName:="c:\My Documents\mybook.xls", _ 
 ReadOnly:=False 
If Workbook.VBASigned = False Then 
 MsgBox "Warning! The project " _ & 
 "has not been digitally signed." _ & 
 , vbCritical, "Digital Signature Warning" 
End If

참고 항목

개념

Workbook Object

Workbook Object Members