Combo-box fails in a protected sheet

[pacharbo]

I am using a validation list-combo box code solution to manage the font size and the number of items that are in the list that is displayed. This works fine while the sheet is not protected. I double click on the cell with the validation list and the combo box code kicks in to display the modified list. When I protect the worksheet, double clicking on the same cell with the validation list does not activate the combo box. The combo box code is attached to the protected sheet. The cell in question is not protected. Can anyone tell me how I can still use this in a protected sheet.

Thanks

[Stuie]

when using vba code, combo box's ect... it runs on the same principles as normal excel..

if a sheet is locked u cant used the locked cells so u need to unprotect the sheet to make the adjustment and then protect it again after eg.

private sub "Name of Sub"()
Dim sh As Worksheet
Set sh = Sheets("Sheet1")

sh.Unprotect "Password1" 'thats if u have a password otherwise leave it off

'now you can do your normal code here

sh.Protect "Password1"

[pacharbo]

Thanks..

I will try this..