EXCEL 2003 ??? on protected sheet

[JazzyLee]

I developed a workbook with Excel 2000 that is password protected and runs with a lot of macro validation using VB codes. A user is trying to access this with MS Excel 2003 and every time she keys an input into any of the cell that they are allowed to enter data into, an annoying little box pops up saying to enter a password to unprotect the sheet. Anyone knows what to do about using this Excel 2000 protected workbook with Excel 2003 and get around this prompt? I cannot afford to unprotect the workbook/worksheet. I included code for userinterfaceonly = true to avoid this problem. Shouldn't this work the same in 2003's version.

 

[PHV]

What is the macro security level of xl2003 ?

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[JazzyLee]

I tried it set on medium and on high and both did not work.

 

[PHV]

I tried it set on medium
And you activated the macros ?

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[JazzyLee]

I made sure I enabled macros and I know it runs because a message displayed while we were trying to input data on the worksheet. The hangup is that the password box pops up on every cell input and I am wondering now if it has anything to do with the macro I execute when a cell value changes. If I click CANCEL when prompted for the password I get to key again but who wants to hit CANCEL every time you enter data into a cell?