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
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