Sunday, May 9, 2021
Home Tags Protect

Tag: protect

Protect VBA

You can protect you complex VBA scripts from modification and copying through the use of password protection. In this post we will demonstrate how to use the standard Excel security to protect you VBA scripts and macros.

Workbook Protection

In this post we will demonstrate the use of Workbook Protection and how it can be used to restrict access to your Spreadsheets. This can be combined with Worksheet Protection for further control access to specific information within your workbooks.

Protecting Cell Data in Excel

After you have a developed an Excel spreadsheet that is going to be used by others you should consider protecting the spreadsheet to guard against any unplanned changes to formulas and formatting by less experienced users. Excel's Cell Protection feature can provide this functionality ensuring that critical formulas are not inadvertently changed when using the spreadsheet.

How to Lock and Protect all Worksheets in a Workbook

In this post we provide a macro that can be used to automatically apply Worksheet Protection to single Worksheet, some Worksheets or all Worksheets in a Workbook. In future posts we will provide an macro that will Disable Worksheet Protection.