Changing value of a combobox on a protected worksheet

**Matt_** · 05-07-2012, 07:29 PM

Worksheet is protected and has some locked items, but it has a combo box that I can change (combobox4).

I want to be able to transfer data from one workbook to that one, and set the combobox value but I don't know how.

Please Login or Register  to view this content.

This is all I've tried, and I get a runtime error 'subscript out of range'. I'm not really sure what else to try.

This works fine for filling in cell values, but it has to be able to change the combobox.

**davesexcel** · 05-07-2012, 08:02 PM

Possibly

Please Login or Register  to view this content.

Though I have not tested it as I do not have workbooks with those names.

**Matt_** · 05-07-2012, 11:04 PM

Class.xlsm
http://www.mediafire.com/view/?36r890bkey6dawl

Second book was >1mb so I couldn't attach.

Still not working. Get 'subscript out of range' with your code, and 'object required' if I mix the two.

I can unprotect it if need be, but it'll usually be protected- so I need a solution for that.

**abousetta** · 05-07-2012, 11:40 PM

You can zip the file and then attach as a .zip file

also you need to provide unlocked, unprotected workbooks. Personally I wouldn't open a locked workbook as a security precaution. The person helping you can then lock it with an empty password (e.g. "") and test.