+ Reply to Thread
Results 1 to 2 of 2

Hiding Partially Locked Rows

  1. #1
    Registered User
    Join Date
    03-11-2014
    Location
    Florida
    MS-Off Ver
    Excel 2010
    Posts
    30

    Hiding Partially Locked Rows

    Hi Folks,

    I have a macro that I'm using to hide rows based on content of another cell. It's this:

    Please Login or Register  to view this content.
    I want to protect the rows that are being hidden/unhidden and only allow certain cells within the row to be changed.

    Basically, if row 25 remains unhidden, I only want someone to be able to change J25, for instance.

    When I try to protect the worksheet, however, the macro can't run to hide the rows. Is there a workaround for this or do I just need to keep the entire row unprotected?

  2. #2
    Registered User
    Join Date
    03-11-2014
    Location
    Florida
    MS-Off Ver
    Excel 2010
    Posts
    30

    Re: Hiding Partially Locked Rows

    Nevermind...I got it. Sorry about that.

+ 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: 4
    Last Post: 10-30-2015, 07:59 AM
  2. Replies: 3
    Last Post: 07-10-2014, 08:11 PM
  3. Conditional partially coping of rows in Excel
    By Floris in forum Excel General
    Replies: 4
    Last Post: 07-22-2010, 10:39 AM
  4. Hiding a button when hiding rows
    By fergusor in forum Excel General
    Replies: 2
    Last Post: 08-10-2006, 09:31 AM
  5. Replies: 4
    Last Post: 08-09-2006, 02:19 PM
  6. Replies: 2
    Last Post: 10-18-2005, 10:05 PM
  7. [SOLVED] Is it possible to do spellcheck in partially-locked excel documen.
    By kchambers in forum Excel General
    Replies: 2
    Last Post: 03-04-2005, 02:06 PM

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