+ Reply to Thread
Results 1 to 4 of 4

Enabling hide/unhide rows in protected sheet

  1. #1
    Registered User
    Join Date
    07-29-2013
    Location
    India
    MS-Off Ver
    Excel 2002
    Posts
    50

    Enabling hide/unhide rows in protected sheet

    Dear Experts, I have been supported by you many times in this forum for various macro requirements, and I am thankful to you all. This time I am with a similar request.

    I have a simple worksheet, which is protected to maintain the drop down list intact in rows 3:150. In these rows, many of them may be empty. I would like to activate hide / unhide rows option, inspite of the sheet protected. Can you please help me out?

    Many thanks for the support.

    gm2612

  2. #2
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2003,2007,2010
    Posts
    31,624

    Re: Enabling hide/unhide rows in protected sheet

    When you protect the sheet, tick the option to allow you to Format Rows


    Regards, TMS
    Trevor Shuttleworth - Excel Aid

    I dream of a better world where chickens can cross the road without having their motives questioned

    'Being unapologetic means never having to say you're sorry' John Cooper Clarke


  3. #3
    Registered User
    Join Date
    07-29-2013
    Location
    India
    MS-Off Ver
    Excel 2002
    Posts
    50

    Re: Enabling hide/unhide rows in protected sheet

    Hello TMS, thanks for the reply, but I tried this before posting the question, and found not working. I am using Excel 2003. Can you please tell me some other method if available?

    Thanks again.

    Regards,
    gm2612

  4. #4
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2003,2007,2010
    Posts
    31,624

    Re: Enabling hide/unhide rows in protected sheet

    No, not really, it's the only way I know.

    See the attached example. Does this work for you? You should be able to change cells from A2 to F20 by selecting from a drop down box. You can hide rows. You can delete values in that range as the cells are unlocked.


    Regards, TMS
    Attached Files Attached Files

+ 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. [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
  2. complicated hide/unhide rows on protected sheet
    By achohan in forum Excel General
    Replies: 15
    Last Post: 06-21-2012, 02:27 PM
  3. [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
  4. Replies: 1
    Last Post: 08-19-2011, 10:25 AM
  5. 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