Protecting Workbooks

Tips, Tricks, and Answers

The following articles are available for the 'Protecting Workbooks' topic. Click the article's title (shown in bold) to see the associated article.

Automatically Protecting After Input
Do you want user-entered data to be immediately protected so that it cannot be changed? This can be done relatively easily using a simple macro.

Protecting an Entire Folder of Workbooks
Want to protect the Excel information stored in a particular folder on your system? There are a number of ways you can approach the task, as described in this tip.

Protecting an Entire Workbook
You can protect an entire workbook so that its structure and its windows cannot be changed. This tip discloses how to apply this protection, and discusses how to configure it for the desired result.

Saving a Workbook Using Passwords
One of the security features built-in to Excel is the ability to save a workbook using a password that limits access to the information in the workbook. You can do this by using some of the features of the Save As dialog box, described in this tip.

Using Macros in Protected Workbooks
Having problems with using macros in a protected workbook? There could be any number of causes (and solutions) as described in this tip.

Visually Showing a Protection Status
Need to know if your worksheets or workbook are protected? By implementing just a quick little macro, you can have that information deposited directly into your worksheet.