Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 12-16-2022, 11:56 PM
abbani abbani is offline Locked ribbon Windows 7 32bit Locked ribbon Office 2010 32bit
Novice
Locked ribbon
 
Join Date: Feb 2016
Posts: 11
abbani is on a distinguished road
Default Locked ribbon

in a protected sheet, ribbon is locked even though cells are not
Reply With Quote
  #2  
Old 12-17-2022, 12:25 AM
Pecoflyer's Avatar
Pecoflyer Pecoflyer is offline Locked ribbon Windows 10 Locked ribbon Office 2021
Expert
 
Join Date: Nov 2011
Location: Brussels Belgium
Posts: 2,779
Pecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant future
Default

And your question is?
__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post
Reply With Quote
  #3  
Old 12-18-2022, 12:27 PM
abbani abbani is offline Locked ribbon Windows 7 32bit Locked ribbon Office 2010 32bit
Novice
Locked ribbon
 
Join Date: Feb 2016
Posts: 11
abbani is on a distinguished road
Default Locked ribbon

why Unblocked cells are locked for coloring and other features in the ribbon when the sheet is locked?
Reply With Quote
  #4  
Old 12-21-2022, 04:49 AM
Debaser's Avatar
Debaser Debaser is offline Locked ribbon Windows 10 Locked ribbon Office 2016
Competent Performer
 
Join Date: Oct 2015
Location: UK
Posts: 221
Debaser will become famous soon enough
Default

You need to specifically allow features like formatting cells when you protect the sheet.
Reply With Quote
Reply



Similar Threads
Thread Thread Starter Forum Replies Last Post
Locked ribbon Size of Outlook Ribbon Changes When Ribbon Is Pinned man_utd_fan Outlook 5 03-24-2021 03:08 AM
locked out of outlook strider Outlook 0 10-29-2018 06:15 AM
Locked ribbon too many clicks with ribbon - ribbon content disappears Rewster Word 2 05-12-2017 08:19 AM
How to import the customized ribbon to Word without overwriting the existing Ribbon? SharonSh Word VBA 0 09-26-2013 11:47 PM
Excel 2010 Ribbon look like 2007's Ribbon esotop Excel 0 03-22-2011 07:05 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 12:24 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft