Home / Tag Archives: lock

Tag Archives: lock

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.

Read More »

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.

Read More »

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.

Read More »