Results 1 to 10 of 10

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

  1. #1

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



    Register for a FREE account, and/
    or Log in to avoid these ads!

    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

  2. #2
    Administrator AliGW's Avatar
    Join Date
    Nov 2015
    Location
    Ipswich, Suffolk, England
    Posts
    1,766
    Articles
    0
    Excel Version
    MS365 Sub (Insider) Win11
    Please take a moment to read our rules on cross-posting: http://www.excelguru.ca/content.php?184

    You will need to add a link to other forums where you have posed the same question, please. Thanks.
    Ali
    Enthusiastic self-taught user of MS Excel!

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

    https://www.mrexcel.com/forum/excel-...s-grouped.html

    Correct file URL:
    https://drive.google.com/open?id=0B5...kdBRTJfZ29Ibjg

    Sorry about the cross post. Didn't realize the points well made in the forum rules that I hadn't read.

    Raudel
    Last edited by RaudelJr; 2017-04-15 at 07:18 AM.

  4. #4
    Administrator AliGW's Avatar
    Join Date
    Nov 2015
    Location
    Ipswich, Suffolk, England
    Posts
    1,766
    Articles
    0
    Excel Version
    MS365 Sub (Insider) Win11
    Thank you for the cross post links.
    Last edited by AliGW; 2017-04-15 at 07:23 AM.
    Ali
    Enthusiastic self-taught user of MS Excel!

  5. #5
    There is one more. Can't seem to find it. I just registered to all. So I'm not really use to this.

    Really feeling scorned. By no means did I want to take advantage of anyone.

    Raudel

  6. #6
    Administrator AliGW's Avatar
    Join Date
    Nov 2015
    Location
    Ipswich, Suffolk, England
    Posts
    1,766
    Articles
    0
    Excel Version
    MS365 Sub (Insider) Win11
    Don't feel scorned - that's not what it's about. What it is about is (a) not wasting people's time if an answer has already been provided and (b) giving potential helpers a chance to see what has already been suggested to avoid unnecessary repetition.
    Ali
    Enthusiastic self-taught user of MS Excel!

  7. #7
    Absolutely, I should have realized it from the beginning. Well hope I didn't scare the help away. I am aware it's all voluntary.

    Thank you and thanks in advance to all that entertain this thread.

    Raudel

  8. #8
    Quote Originally Posted by RaudelJr View Post
    Absolutely, I should have realized it from the beginning. Well hope I didn't scare the help away. I am aware it's all voluntary.

    Thank you and thanks in advance to all that entertain this thread.

    Raudel
    Here is the other thread I couldn't find last night.
    http://www.msofficeforums.com/excel/...tml#post113805

    Thanks again.

    I would really appreciate any help provided.

    Raudel

  9. #9
    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?

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

    Solved, help provided by wonderful user HansV

    Thank you.

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •