+ Reply to Thread
Results 1 to 2 of 2

Hide/Unhide cells on protected sheet

  1. #1
    Spammer
    Join Date
    11-21-2014
    Location
    California
    MS-Off Ver
    2010
    Posts
    387

    Hide/Unhide cells on protected sheet

    Hey guys.

    I have a protected worksheet so that people in my office do not break some hidden formulas.

    There are three columns on the sheet that we want to be able to hide or unhide, so that the sheet can be customer facing at times, and not customer racing at other times. (we dont want to show cost to the customer.... only sell price)

    So unprotected, this is an easy fix... just group the three columns we want to hide (Columns Y:AA), and they can click the plus/minus sign.

    Note: I ONLY want there to be control over columns Y:AA. There are other hidden columns that I do NOT want the user to be able to unhide.


    But when the sheet is protected, they are not able to click those..... How can i get around this?
    Last edited by snuffnchess; 10-14-2015 at 02:01 PM. Reason: Additional Info

  2. #2
    Forum Expert
    Join Date
    01-23-2013
    Location
    USA
    MS-Off Ver
    Microsoft 365 aka Office 365
    Posts
    3,863

    Re: Hide/Unhide cells on protected sheet

    Hi snuffnchess,

    See the attached sample file which may be able to help you. The file contains the following code in an ordinary code module such as Module1:
    Please Login or Register  to view this content.
    Lewis

+ 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. Enabling hide/unhide rows in protected sheet
    By gm2612 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 05-15-2014, 05:16 AM
  2. Unhide Grouped Cells - Protected Sheet
    By SalientAnimal in forum Excel General
    Replies: 9
    Last Post: 04-01-2014, 11:03 AM
  3. [SOLVED] allow hide/unhide rows&columns when sheet protected (macro)
    By jw01 in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 04-15-2013, 03:18 AM
  4. complicated hide/unhide rows on protected sheet
    By achohan in forum Excel General
    Replies: 15
    Last Post: 06-21-2012, 02:27 PM
  5. [SOLVED] VBA Hide/Unhide Rows when Sheet protected
    By Kinez101 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 04-26-2012, 01:34 PM
  6. Replies: 1
    Last Post: 08-19-2011, 10:25 AM
  7. Hide & Unhide columns in Protected sheet
    By Anirudh in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-01-2008, 06:46 AM

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