Skip to content

Latest commit

 

History

History
43 lines (28 loc) · 1.07 KB

Excel.Workbook.VBASigned.md

File metadata and controls

43 lines (28 loc) · 1.07 KB
title keywords f1_keywords api_name ms.assetid ms.date ms.localizationpriority
Workbook.VBASigned property (Excel)
vbaxl10.chm199195
vbaxl10.chm199195
Excel.Workbook.VBASigned
6e93161c-2fa4-1064-9b5d-a8eb96ad2bea
05/29/2019
medium

Workbook.VBASigned property (Excel)

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.

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

[!includeSupport and feedback]