Excel 2007: Protect a Workbook

Posted on Nov 26, 2007 under Office Tips |

How to protect a workbook and disable the options in Excel 2007 to Insert, Delete, Rename, Move or Copy, Hide, and Unhide.

Perform the following steps:

1. Open the workbook and click Review > Changes > Protect Workbook.

2. Under the Protect Workbook dialog box, click Structure. You can set a password if you wish.

Now when a user right-clicks in the workbook, the Insert, Delete, Rename, Move or Copy, Hide, and Unhide options, they will be grayed out.

Outlook 2007: Send a Vote Email (Apr 29, 2008)
Outlook 2007: Check Who Accepted Meeting Invite (Apr 29, 2008)
Outlook 2007: Enable AutoArchive (Apr 22, 2008)
Word 2003: Divide Page Into Columns (Apr 22, 2008)
Word 2007: Divide Page Into Columns (Apr 22, 2008)

Leave a comment