dynamicaly fill dropdown using LISTFILLRANGE

T

thano

Joined
Nov 2, 2007
Messages
1
Reaction score
0
Hi

I am sharing an excel sheet, which have drop downs. these dropdown populae themselves from another sheet using the following code

Sheets("Form").Shapes("Drop Down 1").ControlFormat.ListFillRange = "Tables!Teams1"

this works fine when unshare the workbook but come up with an error message when share it.

error: Unable to set the listfillrange property of the dropdown class

i looked every where but couldnot find any solution. its really important and i would really appreciate if some one can help me with this
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Drop Down Menu Help 3
Unable to get the dropdowns property of the worksheet class??? 13
Problem with setting the ListFillRange in VBA 2
Name Check Box in code 4
Excel Already selected values from DropDown list dynamically updating on multiple sheets 10
Changing ListFill in a shared WKB 7
Userform combobox dropdown question 1
ComboBox Filled by Query 3

Back
Top