P
Pygmalion
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.
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.