Combobox Not Working In Excel Workbook Shared Mode

[peter renton]

Hi

Is there a way to allow combo box to work in shared mode in excel 2010?
i have a sheet that works fine until i try to share the book then it stops

Regards

Peter

[Excel Fox]

Can you post a sample shared workbook that replicates the error you are facing?

[peter renton]

Hi i have attached a sample file this is not shared and the combo box works in column g
is you share the book this stops working , is there a way to work around it ?


Peter

[Excel Fox]

Where's the combobox? Which sheet? Is it a data validation list? Or an actual combobox?

[peter renton]

Hi

the combo box is in the middle sheet in column g (double click and it comes up) it picks the list up from the data sheet,
there is also a validation list on the same column looking up the same list (i did this first and just have not removed it)
when its shared the double click list wont work but the validation list still does.

Peter

[peter renton]

Hi

Dont know if you had time to look at this?
Is there a way to allow the combobox list showingall the names in row a in the data sheet, when i share
the workbook?
There is a validation list that will still work but i have to scroll down the list, it looks and works much better if i can see all items in the list.What ever is selected then auto fills the correct hours/costs etc

I have created the full workbook before i came across the shared problem so i would be gratful for any help in solving this problem

i have added a shared version which shows that if you now double click column g no list appears

PETER

[peter renton]

I have tried attaching another opy of the sheet as the last one didnt have a working combo box for some reason?

[bakerman]

I can't find a validationlist or a combobox in Column G, the only thing i can find is a Userform WITH a combobox which after a few adjustments works fine for me.
One word of advice though, either use the List-method to fill the CB or use a dynamic NamedRange instead of refferring to an entire column.
Also in your sheetmodule there is a lot of code mentioning an object called TempCombo ???

[peter renton]

Hi Thanks for taking a look

Could you tweak the code to the best format for me so i can see what you mean?
I have been adding bits of code to try to make things work so there may be things that dont
need to be there.
This is my first attempt to try to use excel like this so any help would be appreciated.



Peter

[peter renton]

Hi Bakerman

What adjustments did you do to make it work???

Regards

Peter