My control boxes have been disabled !

[Angelo Dundee]

After I have worked in a spreadsheet, then changed some alterations. I found that on re-opening the spreadsheet, that all the different types of control boxes, have been disabled. Can anyone tell me what is likely to have happened ?

ray:

 

[jwpardo]

If you have any group boxes make sure that they still surround the intended controls. Sometimes when we modify row heights or add rows this disrupts the groups.

jp

 

[Angelo Dundee]

I did not do any changes to the sheet on which the controls are.
When I try to change the selection in the list box, it changes, however the INDEX formula doesn't respond, i.e. if I set up an INDEX formula to reference the control ( that is changing ), it doesn't respond for no apparent reason.

=INDEX(Comps1!L8:O27,Z43,4), is the correct formula, but is not responding, even though Z43 ( THE CONTROL ), is changing.

I have noticed that when I now load this spreadsheet, that during loading the cell reference boxes 1 & A1, appear in the top left corner, until the spreadsheet loads, this never happened before.

Does anybody know what this might be ?

 

[Angelo Dundee]

:-> Is this a memory problem ?
My file size is now about 1,300,000 bytes.
The previous versions of this file were less memory than this, and there were no problems.

ray: