dropdownlist/AdvancedFilter/shared workbook
Thank you, I will try. I hope it will not slow down my program. There are
over 1.000 records.
Bye
"WMR" wrote:
Hello,
I always use an AdvancedFilter to get unique record.
The next step is to fill a dropdownlist on a userform. After that
(Combobox_Exit) I fill the rest of de userform with the data of that
customer. This is working for years!
Since I shared the workbook I get an error. I am not allowed to use an
advangedfilter in a shared workbook.
I have two questions:
1. Is there a solution for this problem? There is a lot of functionality in
my sheet using an advancedfilter.
2. Is there an other possibility to get the same result without an
advancedfilter.
I am using Excel 2000.
Thank you.
Willem,
Holland
|