Tips, Tricks, and Answers

The following articles are available. 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. Microsoft Excel versions: 97 | 2000 | 2002 | 2003 | 2007

Protecting an Entire Folder of Workbooks If you have a lot of Excel workbooks in a folder on your hard drive, you may wonder if there is a way to protect them all by simply protecting the folder. Excel doesn’t provide a way, but that doesn’t mean you can’t protect your work. This tip examines four different ways you can achieve the desired result. Microsoft Excel versions: 97 | 2000 | 2002 | 2003

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. Microsoft Excel versions: 97 | 2000 | 2002 | 2003

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. Microsoft Excel versions: 97 | 2000 | 2002 | 2003

Using Macros in Protected Workbooks When you protect or share worksheets and workbooks, it can affect how you use macros. This tip explains the different ways in which your macros can be affected. Microsoft Excel versions: 97 | 2000 | 2002 | 2003

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. Microsoft Excel versions: 97 | 2000 | 2002 | 2003 | 2007

Helpful Links

Ask an Excel Question
Make a Comment

Tips.Net Home

ExcelTips FAQ
ExcelTips Premium

Learn Access Now

Bugs and Pests Tips
ExcelTips
Family Tips
Health Tips
Home Tips
Organizing Tips
WordTips

Advertise on the
ExcelTips Site

 

RSS Feeds

 Daily Nuggets (an ExcelTip every day)

 Allen Wyatt's ExcelTips (the weekly classic)