PhillipsCPA
New Member
- Joined
- Nov 8, 2017
- Messages
- 1
In Excel 2013 from Office 365:
Problem: I lose combo box functionality when I protect my worksheet.
Current solutions I've attempted:
I am using an active X combo box for a drop down list using data validation with a named range (CName).
The only cells I have locked in the entire workbook are the 27 cells with my vlookup formula that enables the drop down value selected becomes the 'lookup value'. Still, when I protect the worksheet it disables the combo box.
The VBA on the sheet is directly copied from this instructional: http://www.contextures.com/xlDataVal11.html under the heading 'Add the Code'
I suspect I'm missing a VBA command but don't know what it should be. Does anyone have any ideas with this problem?
Thank You,
Robin
Problem: I lose combo box functionality when I protect my worksheet.
Current solutions I've attempted:
I am using an active X combo box for a drop down list using data validation with a named range (CName).
- The named ranged of the data validation list (CName) is unlocked.
- CName is on a separate worksheet in the same workbook, but is populated by direct link to another 'central' workbook on our network. I also unlocked the cells that CName links to as well (the central workbook).
- When I open the combo box properties in 'Design Mode' the locked selection is set to 'false'.
The only cells I have locked in the entire workbook are the 27 cells with my vlookup formula that enables the drop down value selected becomes the 'lookup value'. Still, when I protect the worksheet it disables the combo box.
The VBA on the sheet is directly copied from this instructional: http://www.contextures.com/xlDataVal11.html under the heading 'Add the Code'
I suspect I'm missing a VBA command but don't know what it should be. Does anyone have any ideas with this problem?
Thank You,
Robin
