if you dont want to give the user any editing capability..
i'd use a userform iso controls on a sheet.

although you haven't convinced me that DataValidation
wouldn't work in your situation.
lock all cells except the 'status' field..
datavalidate (with list) the statusfield..
changeevent for the sheet triggers the commandbar activation

ELSE:
stick to native controls, forget embedded.
ELSE have ONE CONTROL.
(RE)position that on SelectionChange event


keepITcool

< email : keepitcool chello nl (with @ and .)
< homepage: http://members.chello.nl/keepitcool


Goppi wrote:


keepITcool,

Thanks for your reply. I am actually cleening up the collection in the
deactivate sub. Besides that the amount of rows won't exceed 50.

Validation won't work - The purpose is that I have a list of records
and a status for each record (column 2) - the user shouldn't be able to
edit any cell (perhaps with userinterface protection, but that's not a
topic yet), but just be able to change the status for records. as soon
as he has done that with at least one record a commandbar button should
be enabled...

I didn't know that the activex controls generate files and so on -
perhaps there is a better approach based on the goal described above -
but which one ?


cheers,
pete