If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Excel 2000 vs 2002 Sheet protection & Validation cells
Hello,
I have an Excel spreadsheet built on Excel 2000. I have set sheet protection with password, and I have some unprotected cells with drop down menu (validation with 50 choices) Everything works very well. I sent this file to a friend who has Excel 2002. The same "unprotected" validation cells cannot be modified in his version as the message says that these cells are protected What can be done in order to make it work on his version?? I do have some "very hidden" sheet with password protected VBA properties, if that is an issue. Similarly there are some macros on that same spreadsheet that work on Excel 2000 with the sheet protection on, yet it doesn't work in Excel 2002 with sheet protection on. Any comments would be appreciated. Thanks in advance. André |
#2
|
|||
|
|||
Excel 2000 vs 2002 Sheet protection & Validation cells
All these things should work fine. I just created a workbook with a
validation dropdown and sheet protection on in Excel 2000 and it worked fine in Excel 2002. I think I'd start over again making sure the file I sent was okay. You can send it to me if you want and I'd be happy to test it. Clear out anything propriary. -- Jim Rech Excel MVP "Andre Croteau" wrote in message ... Hello, I have an Excel spreadsheet built on Excel 2000. I have set sheet protection with password, and I have some unprotected cells with drop down menu (validation with 50 choices) Everything works very well. I sent this file to a friend who has Excel 2002. The same "unprotected" validation cells cannot be modified in his version as the message says that these cells are protected What can be done in order to make it work on his version?? I do have some "very hidden" sheet with password protected VBA properties, if that is an issue. Similarly there are some macros on that same spreadsheet that work on Excel 2000 with the sheet protection on, yet it doesn't work in Excel 2002 with sheet protection on. Any comments would be appreciated. Thanks in advance. André |
#3
|
|||
|
|||
Excel 2000 vs 2002 Sheet protection & Validation cells
Hi Jim,
I came across something opposite. I created a macro in which if data in a cell is inconsistent then that cell would get shaded with yellow pattern. The code I wrote in 2002. Sheets(sheetName).Cells(n, a).Interior.ColorIndex = 6 The above used to run fine in 2002 But when the same sheet/code was run in 2000 then I used to get some sort of run time error and the code stopped executing exactly at the line of code pasted above. When the same computer's excel was upgraded to Excel 2003 then the code ran fine. Regards, Hari India "Jim Rech" wrote in message ... All these things should work fine. I just created a workbook with a validation dropdown and sheet protection on in Excel 2000 and it worked fine in Excel 2002. I think I'd start over again making sure the file I sent was okay. You can send it to me if you want and I'd be happy to test it. Clear out anything propriary. -- Jim Rech Excel MVP "Andre Croteau" wrote in message ... Hello, I have an Excel spreadsheet built on Excel 2000. I have set sheet protection with password, and I have some unprotected cells with drop down menu (validation with 50 choices) Everything works very well. I sent this file to a friend who has Excel 2002. The same "unprotected" validation cells cannot be modified in his version as the message says that these cells are protected What can be done in order to make it work on his version?? I do have some "very hidden" sheet with password protected VBA properties, if that is an issue. Similarly there are some macros on that same spreadsheet that work on Excel 2000 with the sheet protection on, yet it doesn't work in Excel 2002 with sheet protection on. Any comments would be appreciated. Thanks in advance. André |
#4
|
|||
|
|||
Excel 2000 vs 2002 Sheet protection & Validation cells
Hello All,
I did send my file to Jim, and he noticed that my "Unprotected" cells were in fact "locked" I assumed that they were unprotected since I was able to modify the content of the cells with a drop down validation. As Jim pointed out: A good question is why the drop downs work in Excel 2000 and not 2002 (and 2003 btw). I think the answer is that MS re-worked worksheet protection in Excel 2002 and "fixed" this intentionally or unintentionally. Thanks Jim for all your help! André "Andre Croteau" wrote in message ... Hello, I have an Excel spreadsheet built on Excel 2000. I have set sheet protection with password, and I have some unprotected cells with drop down menu (validation with 50 choices) Everything works very well. I sent this file to a friend who has Excel 2002. The same "unprotected" validation cells cannot be modified in his version as the message says that these cells are protected What can be done in order to make it work on his version?? I do have some "very hidden" sheet with password protected VBA properties, if that is an issue. Similarly there are some macros on that same spreadsheet that work on Excel 2000 with the sheet protection on, yet it doesn't work in Excel 2002 with sheet protection on. Any comments would be appreciated. Thanks in advance. André |
#5
|
|||
|
|||
Excel 2000 vs 2002 Sheet protection & Validation cells
Sheets(sheetName).Cells(n, a).Interior.ColorIndex = 6
I guess I'd have to know the exact circumstances the error occurred in and the full error message to figure out what the problem is. Of course the code above runs fine in 2000 if you just stick it in a new workbook and run it. -- Jim Rech Excel MVP "Hari" wrote in message ... Hi Jim, I came across something opposite. I created a macro in which if data in a cell is inconsistent then that cell would get shaded with yellow pattern. The code I wrote in 2002. Sheets(sheetName).Cells(n, a).Interior.ColorIndex = 6 The above used to run fine in 2002 But when the same sheet/code was run in 2000 then I used to get some sort of run time error and the code stopped executing exactly at the line of code pasted above. When the same computer's excel was upgraded to Excel 2003 then the code ran fine. Regards, Hari India "Jim Rech" wrote in message ... All these things should work fine. I just created a workbook with a validation dropdown and sheet protection on in Excel 2000 and it worked fine in Excel 2002. I think I'd start over again making sure the file I sent was okay. You can send it to me if you want and I'd be happy to test it. Clear out anything propriary. -- Jim Rech Excel MVP "Andre Croteau" wrote in message ... Hello, I have an Excel spreadsheet built on Excel 2000. I have set sheet protection with password, and I have some unprotected cells with drop down menu (validation with 50 choices) Everything works very well. I sent this file to a friend who has Excel 2002. The same "unprotected" validation cells cannot be modified in his version as the message says that these cells are protected What can be done in order to make it work on his version?? I do have some "very hidden" sheet with password protected VBA properties, if that is an issue. Similarly there are some macros on that same spreadsheet that work on Excel 2000 with the sheet protection on, yet it doesn't work in Excel 2002 with sheet protection on. Any comments would be appreciated. Thanks in advance. André |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Excel 2000: Unprotected cells - How to prevent cursor from wrapping? | Bertus Theron | General Discussion | 1 | June 23rd, 2004 09:02 AM |
excel conversion from 2000 to text in 2002 | jo | Worksheet Functions | 0 | June 10th, 2004 01:59 AM |
Excel 2002 "auto" number format | Norman Harker | Worksheet Functions | 0 | February 26th, 2004 04:40 AM |
Excel 2000 - Worksheet Protection Problem | ksp | Worksheet Functions | 0 | February 18th, 2004 08:12 AM |
importing a works 2000 data base to excel 2002 from xp professional | Dawn | Worksheet Functions | 6 | October 13th, 2003 09:13 PM |