![]() |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
![]()
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, |
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
![]() |
cc3125 | Word | 1 | 10-26-2015 06:44 PM |
![]() |
jc491 | Word VBA | 8 | 09-30-2015 06:10 AM |
![]() |
Bill Martz | Excel | 1 | 04-23-2015 07:57 PM |
![]() |
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 |