Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Allow use of a control scroll bar in protected worksheet
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 |
#2
|
|||
|
|||
Allow use of a control scroll bar in protected worksheet
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. Marco wrote: 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 -- Dave Peterson |
#3
|
|||
|
|||
Allow use of a control scroll bar in protected worksheet
Hi Dave,
In fact, I have a linked cell and if I unprotect it, it works !! Thanks a lot ! "Dave Peterson" wrote: 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. Marco wrote: 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 -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I insert a comment in a protected worksheet ? | Excel Discussion (Misc queries) | |||
Comparing a list to a Calendar worksheet. | Excel Worksheet Functions | |||
Import/Export XML in protected worksheet | Excel Discussion (Misc queries) | |||
Protected Worksheet | New Users to Excel | |||
Drag control onto worksheet does not work | Excel Discussion (Misc queries) |