SOLVED
Home

content protected cells can be deleted even though cell is blocked and worksheet is protected

%3CLINGO-SUB%20id%3D%22lingo-sub-926466%22%20slang%3D%22en-US%22%3ERe%3A%20content%20protected%20cells%20can%20be%20deleted%20even%20though%20cell%20is%20blocked%20and%20worksheet%20is%20protected%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-926466%22%20slang%3D%22en-US%22%3ENot%20all%20sheets%20have%20been%20protected.%20Locked%20cells%20are%20only%20locked%20after%20protecting%20the%20sheet.%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-926493%22%20slang%3D%22en-US%22%3ERe%3A%20content%20protected%20cells%20can%20be%20deleted%20even%20though%20cell%20is%20blocked%20and%20worksheet%20is%20protected%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-926493%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F22322%22%20target%3D%22_blank%22%3E%40Jan%20Karel%20Pieterse%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHi%2C%20thanks%20for%20your%20reply.%20It%20is%20specifically%20about%20cells%20with%20formulas%20in%20the%20last%20tab%20'monitoring%20projecten'%2C%20like%20A5%3AA24.%20These%20cells%20are%20locked%20and%20even%20if%20the%20sheet%20is%20protected%2C%20the%20content%20can%20be%20deleted..%20The%20same%20applies%20for%20example%20J5%3AT24%2C%20Q37%3AT37%2C%20Q39%3AT41%20and%20so%20on..%3C%2FP%3E%3CP%3EMaybe%20I%20forgot%20to%20protect%20this%20sheet%20before%20uploading%2C%20but%20if%20you%20try%20you'll%20see.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-926518%22%20slang%3D%22en-US%22%3ERe%3A%20content%20protected%20cells%20can%20be%20deleted%20even%20though%20cell%20is%20blocked%20and%20worksheet%20is%20protected%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-926518%22%20slang%3D%22en-US%22%3EHow%20very%20odd.%20It%20appears%20as%20if%20your%20file%20is%20(partly)%20corrupted%20somehow.%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-926521%22%20slang%3D%22en-US%22%3ERe%3A%20content%20protected%20cells%20can%20be%20deleted%20even%20though%20cell%20is%20blocked%20and%20worksheet%20is%20protected%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-926521%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F22322%22%20target%3D%22_blank%22%3E%40Jan%20Karel%20Pieterse%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3Eyep%2C%20indeed...%20and%20given%20the%20amount%20of%20referrals%2C%20I%20hope%20there's%20another%20solution%20before%20I%20have%20to%20replace%20it%20completely%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-926669%22%20slang%3D%22en-US%22%3ERe%3A%20content%20protected%20cells%20can%20be%20deleted%20even%20though%20cell%20is%20blocked%20and%20worksheet%20is%20protected%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-926669%22%20slang%3D%22en-US%22%3EI've%20found%20a%20possible%20cause%20for%20this.%20It%20looks%20like%20the%20fact%20that%20you%20have%20set%20up%20%22Allow%20Edit%20ranges%22%20interferes%20with%20the%20worksheet%20protection%20and%20locked%20cells.%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-927057%22%20slang%3D%22en-US%22%3ERe%3A%20content%20protected%20cells%20can%20be%20deleted%20even%20though%20cell%20is%20blocked%20and%20worksheet%20is%20protected%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-927057%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F22322%22%20target%3D%22_blank%22%3E%40Jan%20Karel%20Pieterse%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EYes%2C%20thanks!%20this%20was%20the%20cause%2C%20problem%20solved!%20I%20wasn't%20aware%20of%20this..%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-922097%22%20slang%3D%22en-US%22%3Econtent%20protected%20cells%20can%20be%20deleted%20even%20though%20cell%20is%20blocked%20and%20worksheet%20is%20protected%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-922097%22%20slang%3D%22en-US%22%3E%3CP%3EHi%2C%3C%2FP%3E%3CP%3EIn%20one%20of%20the%20worksheet%20it%20is%20possible%20to%20delete%20content%20of%20protected%20cells%20even%20though%20cells%20are%20blocked%20and%20the%20worksheet%20is%20protected.%26nbsp%3BThe%20workbook%20contains%20macros%2C%20but%20they%20are%20not%20active%20at%20that%20time.%3C%2FP%3E%3CP%3EThe%20workbook%20consists%20of%20several%20sheets%20and%20this%20error%20does%20not%20occur%20there.%3C%2FP%3E%3CP%3EDoes%20anyone%20know%20what%20to%20do%3F%3C%2FP%3E%3CP%3EThanks!%3C%2FP%3E%3CP%3ECiska%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-922097%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3Ecell%20protection%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3Eworksheet%20protection%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
CisDir
New Contributor

Hi,

In one of the worksheet it is possible to delete content of protected cells even though cells are blocked and the worksheet is protected. The workbook contains macros, but they are not active at that time.

The workbook consists of several sheets and this error does not occur there.

Does anyone know what to do?

Thanks!

Ciska

6 Replies
Not all sheets have been protected. Locked cells are only locked after protecting the sheet.

@Jan Karel Pieterse 

Hi, thanks for your reply. It is specifically about cells with formulas in the last tab 'monitoring projecten', like A5:A24. These cells are locked and even if the sheet is protected, the content can be deleted.. The same applies for example J5:T24, Q37:T37, Q39:T41 and so on..

Maybe I forgot to protect this sheet before uploading, but if you try you'll see.

How very odd. It appears as if your file is (partly) corrupted somehow.

@Jan Karel Pieterse 

yep, indeed... and given the amount of referrals, I hope there's another solution before I have to replace it completely

Solution
I've found a possible cause for this. It looks like the fact that you have set up "Allow Edit ranges" interferes with the worksheet protection and locked cells.

@Jan Karel Pieterse 

Yes, thanks! this was the cause, problem solved! I wasn't aware of this.. 

Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
46 Replies
Security Community Webinars
Valon_Kolica in Security, Privacy & Compliance on
13 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
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
Extentions Synchronization
Deleted in Discussions on
3 Replies