combo box not working in shared mode

[peter renton]

Hi

I have attached a sample sheet, every thing works fine until i allow it to be shared then the combo
drop down list does not work (The combo box is only in the test type column) it will still allow the drop list box with scroll bars but i was wanting the full list.
Is there a way to make the combo bo work when sharing the workbook????


Regards

Peter

[peter renton]

Hi
Is there a way to use a user form to show the combo box that will work in shared mode ???


Peter

[JosephP]

userforms should work in a shared workbook just as they do in a normal workbook

[peter renton]

Hi JP

I am unsure how to attach a userform, could you show me an example on he attached file ????
Also i have created a large workbook based on tha attahed sample before i realised the combo box
would not work in shared mode, how can i apply a user form to existing and future sheets??/

Thanks

Peter

[peter renton]

Hi
Can anyone tell me how to change the code to work with an active control combo box? as i am told this type should work in shared mode ??

Thanks for any help

Peter