Drop down Menu

 I am new to EXCEL and using 2007. I have inherited a workbook from a previous employee with drop down menus. I have created my own  drop down menu, but my drop down arrow button only show when I am in the cell. The button is also to the right of the cell and outside it, but the "Help" shows the drop down button inside the cell as is my inherited version which always displays regardless of which cell is active. I probably have more questions on my inherited drop down menu, but for a start can anyone tell me how to get the button inside the cell and to always display.

Garth

Using Excel Toolls there are 3 type of combobox (drop down). two come from the developer tab in Excel (this has to be switched on via Office button>Excel options)

1. ActiveX controls
2. Form Controls

The first are richer in features, but need more programming expertise, No.2 are original, fairly low tech, low feature controls, but easy to work with linked cells, etc.

Both of these types display the dropdown within the confines of the cell providing when the control is designed it is kept within the confines of the cell (using the Alt key is the easiest way)

The third type are those created with the Data Validation feature, using the 'List' option (DV is on the data tab). These have the dropdown outside the cell boundary and do not show when the cell is not selected.

I suepct you have used the latter and the inherited sheet has a 'roll your own' solution? This functionality was the same in versions before 2007 also