Allow Cell Background Fill/Text Color Change while Protected Sheets are Grouped

RaudelJr

New Member
Joined
Apr 14, 2017
Messages
5
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=0B5MLwA6R69-odkdBRTJfZ29Ibjg

Thank you for the help in advance.

Raudel
 

Excel Facts

Which lookup functions find a value equal or greater than the lookup value?
MATCH uses -1 to find larger value (lookup table must be sorted ZA). XLOOKUP uses 1 to find values greater and does not need to be sorted.
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?
 
Upvote 0

Forum statistics

Threads
1,223,880
Messages
6,175,154
Members
452,615
Latest member
bogeys2birdies

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top