'Show message box if the Window is Protected If ThisWorkbook.ProtectWindows = True Then MsgBox 'Windows Protected' ThisWorkbook.Unprotect Checking if a workbook is protected 'Show message box if the Structure is Protected If ThisWorkbook.ProtectStructure = True Then MsgBox 'Structure Protected' Basic Protecting and Unprotecting 'Protect a workbook The code below will work for both MDI and SDI, however protecting the Workbook window will have no use in Excel 2013 and above. However, now that each spreadsheet behaves as if a separate instance, fixing the size of the window now serves no purpose. The purpose of the Windows setting was to fix the size of the spreadsheet within the instance of Excel. When protecting workbooks the Windows option is disabled within Excel 2013 and above. Excel 2013 introduced the Single Document Interface (SDI), where each document has its own window with its own Ribbon. In Excel 2010 and prior Excel had a Multiple Document Interface (MDI), which means multiple workbooks opened within the same Excel window. The difference between Single & Multiple Document Interface

The two topics are closely related, so if this post does not provide the information you need, then read that post too.īefore getting started, there is an important change in Excel 2013 to be considered. In this post, we will consider protecting and unprotecting workbooks. To enable access to VBA, ensure to check the option Trust access to the VBA project object model.In a previous VBA Code Snippet, we covered protecting and unprotecting worksheets. Here, select the Trust Center Settings, and search for Macro Settings: To enable/disable VBA tool, first open Excel, click Options, and find the Trust Center. Next, you must ensure the VBA tool is enabled. In the list that displays, find the add-in Analysis ToolPalk - VBA, and select OK: To enable/disable the VBA tool, first open Excel, click Options, and select Add-ins. This article will explain how to get started with VBA on your Windows computer.

To get started manipulating data, you will need to add the VBA add-in and enable access. However, enabling VBA does not increase your likelihood of contracting a computer virus if you use it correctly and with caution. Microsoft Office is vulnerable to Macro viruses, which can be spread to other documents if VBA is enabled.

Enable or Disable Access to VBA in ExcelĪccess to VBA is turned off by default in Excel as a security precaution.

Vba code not working