Workbook.VBASigned Property

  • Article
Excel Developer Reference

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

Syntax

expression.VBASigned

expression   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.

Visual Basic for Applications 
  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

See Also