+ Reply to Thread
Results 1 to 4 of 4

Changing the Colors with a Protected Sheet

  1. #1
    Registered User
    Join Date
    07-23-2016
    Location
    Rochester, MI
    MS-Off Ver
    ?
    Posts
    2

    Changing the Colors with a Protected Sheet

    Hello, I have a workbook that I would like to have two hidden/locked tabs, but allow for users to still use the Page Layout > Themes/Colors options. Any ideas?

  2. #2
    Forum Expert mikerickson's Avatar
    Join Date
    03-30-2007
    Location
    Davis CA
    MS-Off Ver
    Excel 2011
    Posts
    6,229

    Re: Changing the Colors with a Protected Sheet

    What is the purpose of changing the color of a hidden tab?
    _
    ...How to Cross-post politely...
    ..Wrap code by selecting the code and clicking the # or read this. Thank you.

  3. #3
    Registered User
    Join Date
    07-23-2016
    Location
    Rochester, MI
    MS-Off Ver
    ?
    Posts
    2
    Quote Originally Posted by mikerickson View Post
    What is the purpose of changing the color of a hidden tab?
    The document won't allow you to use the colors option if you have any locked content.

  4. #4
    Forum Expert mikerickson's Avatar
    Join Date
    03-30-2007
    Location
    Davis CA
    MS-Off Ver
    Excel 2011
    Posts
    6,229

    Re: Changing the Colors with a Protected Sheet

    A locked and protected sheet will allow the user to change cell colors if the allow Format Cells box is checked when the sheet is protected.

    My question was why one would want to color a hidden sheet. If no one can see the sheet, what does the color matter?

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Replies: 3
    Last Post: 10-21-2015, 03:51 PM
  2. Protected sheet has cells mysteriously changing to be hidden
    By Bert Uschold in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 04-10-2015, 06:37 PM
  3. [SOLVED] Changing locked cells and colors on a protected sheet
    By DENWARD in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 02-04-2014, 11:49 AM
  4. vba changing sheet tab color when it was protected/not protected
    By mcmunoz in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-17-2013, 05:39 AM
  5. Changing cell validation on a protected sheet
    By agentsmith83 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 02-18-2011, 12:33 PM
  6. Changing a protected sheet from a form
    By JOGIER in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 04-24-2009, 03:21 PM
  7. Changing backgroundcolor of active cell in a protected sheet
    By serge in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 01-24-2005, 11:15 AM

Tags for this Thread

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1