Unlock a spinner or scrollbar on a protected sheet
 

Hi folks,

Excel 2003

I have worksheet with certain cells I would like to protect. If I
protect the sheet then the spinners are locked as well. I tried
unlocking each spinner on the properties tab and when entering the
passord I check allow objects
but no luck so far.

Any ideas would be greatly appreciated. I could email someone the
sheet if that would help.

Thanks

Kevin

If the spinner is linked to a cell, then this must be unlocked (on the
format menu)

Peter

"kevin99" wrote:

Hi folks,

Excel 2003

I have worksheet with certain cells I would like to protect. If I
protect the sheet then the spinners are locked as well. I tried
unlocking each spinner on the properties tab and when entering the
passord I check allow objects
but no luck so far.

Any ideas would be greatly appreciated. I could email someone the
sheet if that would help.

Thanks