Drop Down Box Disappeared

Oct 23, 2007

I have created some drop-down boxes on a tracking spreadsheet. Last week they were they today they are gone.

I went in and cleared the cells and re-created by dropdowns. I did remember to click, in-cell dropdown, but when I click on the cell it is not there.

Now if I right click on the cell it does give me an option to choose from a drop down. So my options are still there but why are they not appearing in the cell when I click on it.

I am using Excel 2003 with Windows XP

View 9 Replies


ADVERTISEMENT

Drop Down Lists Disappeared

Nov 23, 2006

I've created a sheet with a number of drop down lists using the validation menu.

Whilst working on the sheet the lists have disappeared! The validation options are still there and refer to the correct cells that have the correct details in them, but when I click in the cell that should have the list in it I don't get the down arrow to click that shows the list.

I've also tried creating a new list in another cell but that does the same.

Hopefully i've just changed a setting that stops it working and I can unchange it - but I don't know what's caused it.

View 9 Replies View Related

Gridlines Have Disappeared

Oct 26, 2008

I'm not sure what I have clicked on, but I have no gridlines when entering data into my spreadsheet.

View 13 Replies View Related

Tabs Disappeared

Nov 25, 2008

I am unable to view my tabs in excel - the tabs are there, they just can't be clicked on per say. I have double-check the tools option and verified the correct box is check to view tabs, however, I can't view the tabs. I tried to color a tab and it colored it red, but I can't really view the tab. I can see a red line underneath the directional arrows when I am working on that particular worksheet, but again, I can't view/click on the tab.

View 9 Replies View Related

Sum At Bottom Disappeared

May 2, 2007

you know that part at the bottom toolbar which tells you when you select two or more cells what the sum/average/max/min is? Mine's disappeared.

View 2 Replies View Related

Cell Highlighting Box Has Disappeared?

Jan 3, 2013

Was working away on one of my spreadsheets and the black square that surrounds the cell you click on has vanished. i.e. if you click on cell A1, you normally get a black square surrounding the cell A1 to let you know that you are on it. That black square has disappeared.

It seems to affect any spread that I open but if I open a new spreadsheet it is there.

View 4 Replies View Related

Excel File Has Disappeared?

Mar 17, 2014

I have used this file extensively for months. I inadvertently clicked something this morning that made the file "disappear". I can see the file in its folder and open it. But, once opened, I do not see any of the tabs and the name of the file does not appear at the top. I did ALT F11 and can see the tabs in the VBA but I'm missing a step to make the tabs reappear. Since I don't know what I did to make everything disappear,

View 2 Replies View Related

Custom Menu Disappeared.

Jun 17, 2009

Just curious as to what could make a custom menu or custom button disappear from Excel upon opening it. I had created a custom menu with personal.xls macros in it for someone here a while back, and today it was completely missing.. although the Personal.xls folder still existed with the macros.

I am quite sure that they did not manually remove the menu by right-clicking and selecting Customize and dragging back the menu items...

View 5 Replies View Related

Column A Disappeared - How To Get It Back

Jul 24, 2012

Column A disappeared and didn't come back. I even arrow over to the left margin, but the furthest it goes is to column B. How can I get my column A back?

View 5 Replies View Related

Worksheet Tabs Disappeared?

May 18, 2005

I have been presented with a rather odd thing with Excel. We have a wookbook with six worksheets in it. When the first of worksheets is displayed, all the other tabs "disappear". The whole bottom tool/navigation bar is no longer displayed. How can I get it back?

View 8 Replies View Related

VBA - Solver Reference Disappeared -

Oct 30, 2007

When I go to excel ==> ALT + F11 ==> Tools ==> Reference ==> I can't seem to find "solver" anymore. My code was using the solver module, and now my code does not work. I can't find "solver" to check it.

View 2 Replies View Related

Range Name Toolbar/Box Disappeared

Sep 26, 2006

After running a macro, the range name toolbar/display box in Excel has disappeared. how to get it to display again?

View 6 Replies View Related

Series Line Disappeared

Oct 10, 2006

I have a chart of type 'Line' that shows a KPI item measured quarterely. It has a single series that references the 'data' worksheet. Since it is measured quarterely, the months in between will have a null value. It has been working to date, but since I have added the data for the latest month, the series line has disappeared. Only the markers remain. The series line is formatted in a vivid blue.
I can't attach the spreadsheet because its 152KB. One thing of note is that when I select the series line, not all of the markers get highlighted as expected

View 2 Replies View Related

Excel 2010 :: Status Bar Disappeared?

Nov 1, 2010

From time to time, the status bar in excel 2010 is not showing (I don't mean the information is not showing, I mean the bar is not there at all). In previous versions I would go to view>status bar...

how do I get the status bar back in excel 2010?

View 9 Replies View Related

My 'FORMS' Toolbar Has Completely Disappeared

May 21, 2007

My boss has passed me his laptop that he had been designing a spreadsheet on (Excel 2000). The 'forms' toolbar has completely disappeared. When I right click the area where the toolbars are normally docked it lists every one except forms. clicking customise appears to list a few more menus - but no sign of FORMS. If I click 'new' in customise and type in Forms for the name it tells me 'a toolbar named 'forms' already exists' (so where is it!)

how I can get the toolbar back -

View 9 Replies View Related

Relative Reference Button Disappeared

Apr 10, 2007

When I click Tools Macros Record New Macro I usually get a box which allows me to chose relative reference and is displayed until I click stop.

View 4 Replies View Related

Worksheet Tabs & Minimize/Maximize Disappeared

Aug 31, 2007

Edges of worksheet have gone - no tabs, no minimise/maximise.

View 7 Replies View Related

Excel 2003 :: VBA - Worksheet Object Temporarily Disappeared

Oct 25, 2011

I have a simple macro that cycles through the sheets in a workbook, and if the sheet's codename matches one of a defined list, some of its data is added to a summary sheet.

The macro works exactly as intended, but a strange thing happened yesterday: some data was missing from the summary sheet because one of the sheets was being ignored. This sheet is named 'MCP' on its tab, and has codename Sheet8.

Here's the strange part: on stepping through the code, cycling the sheets, I noticed that the sheet icon, name and codename had disappeared from the Microsoft Excel Objects folder in the Project Explorer. When the loop got to the sheet in question

Code:
For Each ws In ThisWorkbook.Worksheets
Debug.Print ws.Name
Debug.Print ws.Codename

The above code displayed its name (correctly) as 'MCP', but its codename was blank; the sheet was therefore skipped by the code because the codename had to match against a defined list.

While I was pondering this, and doing some web searches, the sheet then re-appeared in the Project Explorer and everything worked again.

My question is this: is it likely to be due to the workbook being shared? I know that workbook sharing in Excel is often discouraged, but this is a simple workbook only used by a maximum of three users (two of these had the workbook open at the time the issue was reported)

I've changed the code so that the sheet name is inspected in the event that the codename is blank, which should guard against the issue provided sheets are not deleted/renamed.

Windows XP, Excel 2003

View 4 Replies View Related

What Its Called When You Have Drop Down Menus That Correspond With Other Drop Down Me

Nov 22, 2008

what its called when you have drop down menus that correspond with other drop down menus.

View 2 Replies View Related

Populate Drop-Down Based On Another Drop-Down Choice

Oct 25, 2006

Here is what I'm trying to do:

I have 4 sheets:
1 called main
1 called states
1 called counties
1 called people

On "main" I have 1 drop down box and 1 cell:

the drop down lists the states from "states" sheet
the cell, which i would like to have as a drop down is supposed to be listing the counties in the state selected from the 1st drop down. right now it is setting the value to TRUE for testing purposes.

then when the county is selected, it will display the people in that county listed in "people". So far I can only get the 1st drop down to list the states. that's the easy part. i need to getting the counties to list in another drop down based on what state is selected.

View 2 Replies View Related

Populate Drop-Down Based On Another Drop-Down Selection ...

Dec 5, 2007

Im a fairly basic VBA user who has just purchased the code for J-Walk's Enhanced Data Form.

On other threads in this forum I have noticed a lot of people asking how to make the contents of one drop-down box dependant on the selection in another. I am trying to do the same thing but with the criteria section of the EDF form.

Is this possible? What does give me hope is that a simple Autofilter - whilst not as aesthetically pleasing, does the job well.

View 3 Replies View Related

Populate Drop-Down Based On Another Drop-Down Selection

Aug 7, 2008

Currently I have columns fixed or assigned to the names of insurance providers/companies.

In each column below the name of the Insurance Company, a combobox containing the plans that company offers. Choose a plan, and the rest of the column is filled in using vlookup.

Now to save space, IE opposed to having 13-15 columns one assigned to each Insurance Company/Provider. I am looking to have only 3-5 columns with a first initial combobox in which one chooses the Name of the Company/Provider, and in turn populate the original combobox and vlookup functionality I already have built in.

Here is an example of what I am working with.
[url]

View 3 Replies View Related

Drop Down List Which Returns Values Based On What Has Been Selected In The Previous Drop Down List In The Adjacent Cell

Mar 19, 2009

I'm trying to create a drop down list which returns values based on what has been selected in the previous drop down list in the adjacent cell, e.g. if 'Apples' is selected in the previous cell then you should only be able to select from 'Gala, Granny Smith', or if 'Oranges' is selected you should only be able to select 'Seville, Blood Orange'. Is there a formula which would do this, or can I use a pivot table somehow? I'm totally stumped.

View 2 Replies View Related

Selection From One Drop Down Creates New Drop Down

Mar 1, 2007

In the attached example I am trying to get the selections from one drop down to gnerate available selections in the next. The first drop down is the door style. This then needs to generate the possible drop downs in wood species. This then needs to generate the possible drop down in available stains. this then needs to generate the related door factor....

View 9 Replies View Related

Drop Down List Which Displays A Different Set Of Values Depending Upon The Value Selected By A Previous Drop Down List

Oct 26, 2009

I need to have a drop down list which displays a different set of values depending upon the value selected by a previous drop down list. ie. (drop down box 1)= x, y, z. (drop down box 2)= either x1, x2, x3, or y1, y2, y3, or z1, z2, z3. I can produce a single drop down box thats not a problem but linking several drop down boxes is beyond me .

View 4 Replies View Related

Drop Drop Menus

Oct 5, 2009

I receive inspection sheets from mechanics and I need to start tracking trends. So, let's say the mechanic has marked an "interior" issue and of the 10 potential items that could related to "interior", he has chosen "dirty upholstery" -

Column A is drop down menu with four categories listed:

Interior
Exterior
Transmission
Undercarriage

So in Column A from the drop down menu I pick the main category of Interior. Then it's on to Column B to choose the exact issue of the Interior. When I choose "Interior" in Column A I would like Column B to automatically show me another drop down list with issues that relate only to Interior (i.e. glass, dirty upholstery, torn upholstery, etc.)

that is question #1....

If there are multiple issues on one vehicle, I would then go to Column C, pick another category (i.e. Transmission) and then in Column D, I would like it to automatically display the drop down menu that relates to Tranmission issues (engine oil, air intake, engine wiring, etc.).

View 4 Replies View Related

Drop Down List Values Dependant On Value Of Another Drop Down List

Dec 9, 2009

I have a drop down box in column N, however I would like the options in that drop down box to change depending on what appears in column M.

If column M Says "Lapse" then I want one drop down box to appear in column N, If coumn M says "NTU" then I would like column N to show different drop down options.

View 12 Replies View Related

Drop Down

May 3, 2009

i am trying to figure out how to write a formula and trying to figure out what type of formula to use to do this, been reading alot latley. i have a data verification drop down with many items in it. when an item is selected i want it to give two other responces in a selected column.
ITEMQUANTITYUNIT DESCRIPTION150ALF8" DI Water150BLF6" DI Water

what i am after is this. i open the data verification drop down for 8" DI Water, when that item is selected i want it to install the appropiet unit number that would be LF (lanier foot) and also input the item which is 150A. i have a list of 80 items all that have their own unit and item number. This would save me alot of time.

View 9 Replies View Related

Drop Down/ List Box

May 22, 2008

i have a spreadsheet with several fields. i want to derive information from this data. i want to be able to control the output through the use of list/drop down boxes.

so the user will choose several criteria AND based on this criteria, the ouutput will reflect user requirements.

View 12 Replies View Related

Drop Down Menus

May 22, 2008

I want to have a spread sheet where a user will pick an option from a drop down list, then based on that option choice, have a different cell populate with a specifc drop down menu.

Example:

Cell A1 has a drop down with three choices (1,2,3)
User selects option 1
Cell B1 will now have a drop down with options A,B,C
However:
If user selects option 2 from A1
Cell B1 will now have a drop down menu with options X,Y,Z

View 11 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved