Two problems with Excel 2007
 

I have problem with two features that worked in previos versions of
Excel but do not work any more.

1. I have a few textboxes on my chart, which refer to cells on the
same sheet (e.g., content of textbox is =KM!$A$1). These textboxes no
longer work - they are empty and font and formatting is automatically
changed. What is wrong?

2. I am using VBA code to change chart axes of a chart on unprotected
area of the sheet. This no longer works and I have to .Unprotect
sheet before making changes. Why is that so? Is it possible to
unprotect only chart (like individual cells) and how?

Thanks for the answers.

Regards, Marko.