Tag Archives: protect

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.

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.

February 15, 2011ProtectionComments Off on Protecting Cell Data in Excel1,554

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.

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.

At the Excel Help Desk we are focused on providing solutions to Excel problems

We help thousands of users every day by providing answers to Excel problems, ranging from basic spreadsheet formatting issues to complex formula calculations that extend Excel to its limits. If you can’t find a solution to your problem on our site then Contact Us with a description and we will endeavour to post a solution as soon as possible.