Does anyone know if there is a way to make a drop-down list appear when a cell is double-clicked as opposed to just clicking on the box to the right of the cell that appears when you click in the cell? I want to be able to use the ability to drag-copy the cell contents from the little square in the bottom-right of the cell, but cannot do this when there is a validation drop-down list!!
Last edited by TheRetroChief; 10-29-2008 at 08:35 AM.
well i can! you just have to wait until cursor changes to black + then left click
Well, i can assure you, that doesn't happen for me!!!!
At the moment I am using Excel 2000. When I click on the cell with validation the drop down appears. However, using the mouse to hover over the bottom right corner allows me to drag the cell downwards. This is a common way to copy cells with validation.
Hope that helps.
RoyUK
--------
For Excel Tips & Solutions, free examples and tutorials why not check out my web site
Free DataBaseForm example
I know, i do it all the time!!!
It's there in cells without validation, but I can't get to it in cells with drop-down lists!!!
It should be
Try it on the example spreadsheet i sent you on monday if you can. It doesn't work on there either on any of the cells with drop-downs. I can right-click, drag and then select options. But can't do the simple drag to copy. My cursor doesn't change to the black cross!
Works fine on the example that you sent. Have you added any protection?
I opened the attachment i sent you and tried it there!! That makes no sense to me whatsoever - why it works for you and not for me. Any thoughts? I didn't do anything to the attachment, it should be exactly as you recived it.
No, maybe you could run repair from the Office CD
Okay, this is weird now. It still works fine on one of the other spreadsheets that I've been working on that link from this one. I have them both open at the same time. It also works on the worksheets that the data is extracted to in that workbook!
Have you checked sheet protection? I'm limited to 2000 here
Ah....when i unlock the sheets, the cells with validation can then be used. The cells themselves aren't locked tho. Doesn't the macro handle the protection?
I shall investigate with the options you have when you lock the sheet.
Ah, it works when i have the edit object option checked when protecting sheets. It obviously count cells with validation as different to those without then?
Not solved at all in fact.
When i do as above, i can use the black +. However, as soon as i use the calendar, my original problem resurfaces. There must be something in the Calendar Macro causing the problem.
How do i change the protection command with in the macros to allow you ability to edit objects?
I assume that when the macro turns protection back it, it resets and you can no longer edit objects, that is what appears to be happening.
This is what i have at present
Please Login or Register to view this content.
Last edited by TheRetroChief; 10-29-2008 at 10:23 AM.
Should i post this as a new problem, or is it ok to carry on in here?
Using the calendar does not affect it for me
Must be a 2003 thing then??
I will check when I can get on my laptop
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks