how to password protect cells in excel 2003

#How to password protect cells in excel 2003 update#
#How to password protect cells in excel 2003 code#

Protecting one sheet at a time manually works. However if you save the file in 2007 format the setting is lost. I also found out that if you save the file as an Excel 97-2003 workbook, the selection restrictions will be saved. Unfortunately this bug also exists in Excel 2007 ( and ) and I haven't seen a fix for this.

To download the service pack from Office Update, visit the following Microsoft Web site:

#How to password protect cells in excel 2003 update#

(page no longer available) Solution Office update More information about this Excel bug in Excel 2002/XP and 2003:Įxcel 2002 post-Service Pack 3 hotfix package: May 6, 2004ĭescription of the Excel 2003 post-Service Pack 1 hotfix package: August 20, 2004 Additionally, locked cells cannot be selected when the workbook is opened. If you set the EnableSelection property manually, the changes are saved. After the workbook is saved, closed, and then opened, cells that you expect to be locked can be selected. When you try to use a Microsoft Visual Basic for Applications (VBA) macro to set the EnableSelection property in Microsoft Excel 2002 or in Microsoft Office Excel 2003, the EnableSelection property is not saved. Microsoft has confirmed that this is a problem in Excel 20: KB918323 After I installed the service pack the utility worked as expected.

#How to password protect cells in excel 2003 code#

So if you want to use code to unlock some cells, you have to unprotect the workbook/worksheet first. You aren't able to unlock the cells, even using VBA code, if the sheet is protected. I found in the MS Knowledge base that this is a bug that is fortunately fixed in one of the Excel service packs. Every cell on excel is Locked by default and after protecting a workbook, you won't be able to edit the cells unless you unlock them beforehand. At first it looks just right but when you save, close and re-open the file the setting of selecting only unlocked cells was lost. Recently I got the following question: ' When using the 'protect multiple sheets at once' and checking only the 'select unlocked cells' checkbox I find that once I save and reopen the sheets now behave as if both the 'select unlocked cells' as well as the 'select locked cells' seems to be in effect as I can then select any cell, however, the rest of the protections seem to be in place.'Īt first I couldn't reproduce the problem, however when I did it on a computer with Excel 2003 without any service packs installed I could replicate the problem. (this article was previously published on our weblog) Question As is the case with any password, choose a strong and secure combination of letters, numbers, and characters, bearing in mind that passwords are case-sensitive. Click on the Protect Workbook dropdown option and choose Encrypt with Password. Protect sheets: The EnableSelection property is not saved + Excel update fix Published: Octo(latest revision April 1, 2022) While working in Excel, navigate to the File tab choose the Info tab.