HI,

I have a project Gannt chart where I can scroll the annual calendar via an embedded scroll bar.
I want to be able to manually add text / change cell colour but when I do, the editing is locked in place so when I scroll the embedded scroll bar, the editing doesn't move with the calendar.

Using the main sheet scroll bar does move it along with the whole sheet but that doesn't help when I need to move the project calendar on.

How do I "unlock" those cells to allow me to edit them manually?

(Javascriptvoid error)excel help.JPG

Many thanks,
KCopy of Production programme DRAFT.xlsx