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
Highlighted
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
Tabs and Dark Mode
cjc2112 in Discussions on
35 Replies
Extentions Synchronization
Deleted in Discussions on
3 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
29 Replies