unprotecting a combobox in your spreadsheet

P

philipl

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top