Allow use of a control scroll bar in protected worksheet

M

Marco

Hi all,
I have a control Scroll Bar in my worksheet (Excel 2003). I want to protect
everything except the use of that scroll bar (let the possibility to scroll).
I've tried to play with all the options in the Protect Sheet dialog box....
but when I click my scroll bar it doesn't want ! Any clue would be very
apreciated. Thanks !

Marco
 
D

Dave Peterson

Do you have a linked cell assigned to that scrollbar?

If you do then that cell can't be locked on a protected worksheet. You could
either unlock it or assign a linked cell on a different worksheet.
 
M

Marco

Hi Dave,
In fact, I have a linked cell and if I unprotect it, it works !!
Thanks a lot !
 
Top