Dear all,

I am making an excel spreadsheet for 2007 and 2003. The way I am doing this
is making everything in excel 2007 and save is as excel 2003 (compatibility
mode). In the VBA, I wrote:

The code above controls a chart where the n is total points (dots) that is
going to be plotted. The chart is XYscatter style (only dots, no lines).

I saved it, everything works very well!

I put a mouse scroll protection (vba code) on the sheet and protect the
sheet with password. All boxes contain formulas/results are not locked.

With the protection, this sheet works fine in excel 2003, however, excel
2007 says error for:

It said:

Is this a bug in excel 2007? I know that I am going to save this worksheet
as excel 2007 (.xlsm I guess if I am not mistaken with the file name), but
how do I make this working?

I also made a copy and converted the new copy to 2007 version (.xlsm), it
seems that the problem still exists. I really do not have any ideas how to
solve this problem.

Please help and advice. Thank you in advance.