Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 04-14-2017, 09:28 PM
RaudelJr RaudelJr is offline Allow Cell Background Fill/Text Color Change while Protected Sheets are Grouped Windows 10 Allow Cell Background Fill/Text Color Change while Protected Sheets are Grouped Office 2013
Novice
Allow Cell Background Fill/Text Color Change while Protected Sheets are Grouped
 
Join Date: Apr 2017
Posts: 9
RaudelJr is on a distinguished road
Default Allow Cell Background Fill/Text Color Change while Protected Sheets are Grouped

I'm working on a Template that will be Themed buy a few members on a monthly basis.

All the Sheets are protected and the user is to basically just Background Fill the Cells, etc.

All Sheets are to be Themed Identically. But to avoid doing the same thing on each Sheet, they group the sheets first and then Theme just the first sheet which in turn carries the same to the rest of the sheets.

Unfortunately, Excel gives an error when changing the background with all sheets grouped even when all the
[ ] checkboxes are selected upon protecting the sheets.

Is there away to make theming of all the sheets at once while keeping them protected?

I want to prevent the users from editing the text and the structure of the sheets/workbook but have full freedom to format the cells background/colors/

My Sample Workbook:
https://drive.google.com/open?id=0B5...kdBRTJfZ29Ibjg

Thank you for the help in advance.



Raudel

Last edited by RaudelJr; 04-14-2017 at 09:40 PM. Reason: format cells, grouped sheets, protected Sheets, unprotected, group,
Reply With Quote
  #2  
Old 04-15-2017, 12:49 PM
RaudelJr RaudelJr is offline Allow Cell Background Fill/Text Color Change while Protected Sheets are Grouped Windows 10 Allow Cell Background Fill/Text Color Change while Protected Sheets are Grouped Office 2013
Novice
Allow Cell Background Fill/Text Color Change while Protected Sheets are Grouped
 
Join Date: Apr 2017
Posts: 9
RaudelJr is on a distinguished road
Default

Below are other forums where I've requested some help with this same request.


https://answers.microsoft.com/en-us/...5-64d39648e3de


https://www.mrexcel.com/forum/excel-...ml#post4803466

http://www.excelguru.ca/forums/showt...1532#post31532

Any help will be really appreciated.

Raudel
Reply With Quote
  #3  
Old 04-16-2017, 11:49 AM
RaudelJr RaudelJr is offline Allow Cell Background Fill/Text Color Change while Protected Sheets are Grouped Windows 10 Allow Cell Background Fill/Text Color Change while Protected Sheets are Grouped Office 2013
Novice
Allow Cell Background Fill/Text Color Change while Protected Sheets are Grouped
 
Join Date: Apr 2017
Posts: 9
RaudelJr is on a distinguished road
Default

I've tested code such as:

Private Sub Workbook_Open()
For Each ws In Sheets
With ws
.Unprotect Password:="Protect"
.Protect Password:="Protect", UserInterfaceOnly:=True, AllowFormattingCells:=True, AllowFormattingColumns:=True, AllowFormattingRows:=True
.EnableOutlining = True
End With
Next ws
End Sub

Where I change Trues to False, but the only one that works is
Content:=False
But that defeats the purpose since all content is editable.

Any ideas?
Reply With Quote
  #4  
Old 04-16-2017, 11:26 PM
RaudelJr RaudelJr is offline Allow Cell Background Fill/Text Color Change while Protected Sheets are Grouped Windows 10 Allow Cell Background Fill/Text Color Change while Protected Sheets are Grouped Office 2013
Novice
Allow Cell Background Fill/Text Color Change while Protected Sheets are Grouped
 
Join Date: Apr 2017
Posts: 9
RaudelJr is on a distinguished road
Default

I see this Item marked as solved, but it isn't Solved yet.

Is there a solution?
Reply With Quote
  #5  
Old 04-17-2017, 08:01 AM
RaudelJr RaudelJr is offline Allow Cell Background Fill/Text Color Change while Protected Sheets are Grouped Windows 10 Allow Cell Background Fill/Text Color Change while Protected Sheets are Grouped Office 2013
Novice
Allow Cell Background Fill/Text Color Change while Protected Sheets are Grouped
 
Join Date: Apr 2017
Posts: 9
RaudelJr is on a distinguished road
Default

I really would appreciate some help on this. I'm the only one that has replied to my own question and the topic has been marked as Solved. But I still haven't figured it out yet.
Reply With Quote
  #6  
Old 04-18-2017, 11:11 PM
RaudelJr RaudelJr is offline Allow Cell Background Fill/Text Color Change while Protected Sheets are Grouped Windows 10 Allow Cell Background Fill/Text Color Change while Protected Sheets are Grouped Office 2013
Novice
Allow Cell Background Fill/Text Color Change while Protected Sheets are Grouped
 
Join Date: Apr 2017
Posts: 9
RaudelJr is on a distinguished road
Default

http://www.eileenslounge.com/viewtop...205930#p205930

Solved, help provided by wonderful user HansV

Thank you.
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Allow Cell Background Fill/Text Color Change while Protected Sheets are Grouped Remove white text background (keeping the font color and page color intact cc3125 Word 1 10-26-2015 06:44 PM
Allow Cell Background Fill/Text Color Change while Protected Sheets are Grouped VBA Table – Search All Tables - Find & Replace Text in Table Cell With Specific Background Color jc491 Word VBA 8 09-30-2015 06:10 AM
Allow Cell Background Fill/Text Color Change while Protected Sheets are Grouped Entering a number in a cell causes it to fill with the color of a nearby cell Bill Martz Excel 1 04-23-2015 07:57 PM
Allow Cell Background Fill/Text Color Change while Protected Sheets are Grouped Cell Background Color: Base it on Content of Cell? tatihulot Excel 4 08-14-2013 03:24 PM
How can I fill cell color starting from Cell D5 using Conditional formatting instead Learner7 Excel 0 07-08-2010 05:50 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 11:04 PM.


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