Home

Protect cells while leaving scroll bars operative

%3CLINGO-SUB%20id%3D%22lingo-sub-454170%22%20slang%3D%22en-US%22%3EProtect%20cells%20while%20leaving%20scroll%20bars%20operative%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-454170%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20a%20fairly%20simple%20sheet%20that%20has%2012%20scroll%20bars%20for%20users%20to%20control%20-%20but%20however%20I%20try%20to%20leave%20them%20operative%20whenI%20protect%20the%20sheet%20or%20the%20work%20book%2C%20nothing%20works.%20It%20works%20if%20I%20protect%20the%20sheet%26nbsp%3B%3CEM%3Eup%20to%3C%2FEM%3E%20the%20scroll%20bars%20but%20not%20if%20I%20include%20them%2C%20leaving%20cells%20past%20them%20unprotected.%20I've%20tried%20creating%20an%20'island'%20of%20unprotected%20cells%20around%20the%20scroll%20bar%20but%20that%20doesn't%20work%20either%20-%20the%20scroll%20bars%20remain%20inoperative%20with%20the%20message%20that%20I'm%20trying%20to%20access%20protect%20cells%20if%20I%20try%20to%20change%20them.%20And%20I%20HAVE%20unchecked%20the%20'Locked'%20selector%20in%20the%20Scroll%20bar%20format%20box.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI'm%20on%20a%20Mac%2C%20OSX%2010.14.4%20Office%20365.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20will%20appreciate%20any%20advice%20on%20how%20to%20get%20around%20the%20problem!%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ETIA.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ETerence%20Watts%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-454170%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
TerenceW-77
Occasional Visitor

I have a fairly simple sheet that has 12 scroll bars for users to control - but however I try to leave them operative whenI protect the sheet or the work book, nothing works. It works if I protect the sheet up to the scroll bars but not if I include them, leaving cells past them unprotected. I've tried creating an 'island' of unprotected cells around the scroll bar but that doesn't work either - the scroll bars remain inoperative with the message that I'm trying to access protect cells if I try to change them. And I HAVE unchecked the 'Locked' selector in the Scroll bar format box.

 

I'm on a Mac, OSX 10.14.4 Office 365.

 

I will appreciate any advice on how to get around the problem!

 

TIA.

 

Terence Watts

Related Conversations
Extentions Synchronization
ChirmyRam in Discussions on
3 Replies
Tabs and Dark Mode
cjc2112 in Discussions on
35 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies