hi,

I have a combox box on my spreadsheet. I use code to protect cells and
this combobox from being changed in my spreadsheet, when user want
this. but when user manually select unprotect-spreadsheet in excel's
menu under tools. It only unprotects cells in my spreadsheet and my
combo box is left locked. Does any one know how to:

-work around this?
-know if its possible to customise excels unprotect functionality in
the menu, using code or manually?

I know i can probably improvise by using the onchange event but i'd
rather something cleaner.

thx for your help
-Philip