|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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, |
#2
|
|||
|
|||
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 |
#3
|
|||
|
|||
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? |
#4
|
|||
|
|||
I see this Item marked as solved, but it isn't Solved yet.
Is there a solution? |
#5
|
|||
|
|||
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.
|
#6
|
|||
|
|||
http://www.eileenslounge.com/viewtop...205930#p205930
Solved, help provided by wonderful user HansV Thank you. |
Thread Tools | |
Display Modes | |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Remove white text background (keeping the font color and page color intact | cc3125 | Word | 1 | 10-26-2015 06:44 PM |
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 |
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 |
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 |