My control boxes have been disabled !

Angelo Dundee

Board Regular
Joined
Nov 18, 2002
Messages
167
:rolleyes: 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 ?

:pray:
 

Excel Facts

Shade all formula cells
To shade all formula cells: Home, Find & Select, Formulas to select all formulas. Then apply a light fill color.

jwpardo

New Member
Joined
Dec 17, 2003
Messages
22
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

Board Regular
Joined
Nov 18, 2002
Messages
167
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

Board Regular
Joined
Nov 18, 2002
Messages
167
:-> 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.

:pray: :rolleyes: :eek:
 

Watch MrExcel Video

Forum statistics

Threads
1,130,112
Messages
5,640,174
Members
417,130
Latest member
Darion2021

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top